amr.moussa.87 (6/19/2014)
i have tried many thingi have table called visiting, it have two column (visiting date) and ( cost ) like that
visiting_date cost
20-6-2014 50
20-6-2014 50
21-7-2014 200
21-7-2014 200
i want to make view that can sum cost of each month individual so output will be
month income
6 100
7 400
than you for helping
What do you want to display when the year changes over?
--Jeff Moden
Change is inevitable... Change for the better is not.