Sum in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Help please!!!
I am having a hard time totaling in the reports by year.
ie:

Group Name Year Charge

Basketball 2001 10.00
2002 80.00
2003 150.00
Football 2001 20.00
2002 20.00
2003 20.00
Total 2001 30.00
2002 100.00
2003 170.00

When I sum the Charge field I get the total of all years together. I have
grouped the report with Group Name - then - Year but I can't seem to sum just
the year for the charges. Need help

Thanks
 
When I sum the Charge field I get the total of all years together. I have
grouped the report with Group Name - then - Year but I can't seem to sum
just
the year for the charges. Need help
Click to expand...

Make sure you have the footers turned on for the Year section. A Sum put in
that footer will be the sum of the year.

Tom Lake
 
Tom Lake said:
Make sure you have the footers turned on for the Year section. A Sum put in
that footer will be the sum of the year.

Tom Lake


Tom,
Click to expand...

That did not work because I am grouping on Group name first and then on
year. Any other suggestions?
 
Make sure you have the footers turned on for the Year section. A Sum put
That did not work because I am grouping on Group name first and then on
year. Any other suggestions?
Click to expand...

You could use DSum with the year as the criterion

Tom Lake
 
Back
Top