G
Guest
I need to write a query (in design view) which will sum the total account
value for each customer, split by month. The date field in my database
(it_date) is in the format of dd/mm/yyyy, with the 'dd' always set to the
last day of the relevant month, so all Jan 2007's will be displayed as
31/01/2007, all Feb 2007's will be displayed as 28/02/2007, etc.
What expression do I need to group the amounts (it_amount) by month (looking
only at dates >01/01/2005), so that the results look similar to below?
Customer Ref Date Total Account Value
1234 Jul-07 500
1234 Jun-07 400
2468 Jul-07 300
2468 May-07 333
Thanks in anticipation.
value for each customer, split by month. The date field in my database
(it_date) is in the format of dd/mm/yyyy, with the 'dd' always set to the
last day of the relevant month, so all Jan 2007's will be displayed as
31/01/2007, all Feb 2007's will be displayed as 28/02/2007, etc.
What expression do I need to group the amounts (it_amount) by month (looking
only at dates >01/01/2005), so that the results look similar to below?
Customer Ref Date Total Account Value
1234 Jul-07 500
1234 Jun-07 400
2468 Jul-07 300
2468 May-07 333
Thanks in anticipation.