M
mahmad
Hi,
I want to be able to sum by daily amounts and then sum them up so i get a
total for the month gone. So yesterdays figures will be added to the day
before etc and summed up.
Amount Date Team
------- ------- --------
200 09/03/08 Blue
100 10/03/08 Blue
200 11/03/08 Green
Total 300 for Blue and 200 for Green in March so far then tomorrow it will
add what ever value Amount
is and so on for the whole month. Next month will then start from scratch.
Thanks
MO
I want to be able to sum by daily amounts and then sum them up so i get a
total for the month gone. So yesterdays figures will be added to the day
before etc and summed up.
Amount Date Team
------- ------- --------
200 09/03/08 Blue
100 10/03/08 Blue
200 11/03/08 Green
Total 300 for Blue and 200 for Green in March so far then tomorrow it will
add what ever value Amount
is and so on for the whole month. Next month will then start from scratch.
Thanks
MO