M
mahmad
Hi,
I currently have a table which holds the following:
Team Amount Date
------ --------- -----
Blue 100 01/01/08
Red 200 01/01/08
Green 500 01/01/08
Yellow 50 01/01/08
Team Amount Date
------ --------- -----
Blue 100 02/01/08
Red 200 02/01/08
Green 500 02/01/08
Yellow 50 02/01/08
I am able to show these on a graph on a daily basis, how can show sum the
Amount for each team as the days go by so i can show them on a graph for a
whole month. So i would have something like this:
Team Amount
------ ---------
Blue 200
Red 400
Green 1000
Yellow 100
Thanks
Mo
I currently have a table which holds the following:
Team Amount Date
------ --------- -----
Blue 100 01/01/08
Red 200 01/01/08
Green 500 01/01/08
Yellow 50 01/01/08
Team Amount Date
------ --------- -----
Blue 100 02/01/08
Red 200 02/01/08
Green 500 02/01/08
Yellow 50 02/01/08
I am able to show these on a graph on a daily basis, how can show sum the
Amount for each team as the days go by so i can show them on a graph for a
whole month. So i would have something like this:
Team Amount
------ ---------
Blue 200
Red 400
Green 1000
Yellow 100
Thanks
Mo