Sum groups in a report

R

Ronnie

I have a report which is based on 3 queries. I would like to add a sum to a
group of items within a year. Is there a way I can do this on the report, or
should I do this through by entering the criteria in one of the queries?
 
W

Wayne-I-M

Hi Ronnie

If you have a date field included within the report you can group the
records by year and then place a sum in the group footer.

Use this is the sorting grouping options box =Year([DateField])
 
R

Ronnie

Yes, I have a date field included in the report, and I was able to enter a
group footer. However, it is giving me a sum after each item rather than at
the end of the year. I tried a few things, but was unable to get it to work.
I'm not sure where the sorting grouping options box is.
--
Ronnie


Wayne-I-M said:
Hi Ronnie

If you have a date field included within the report you can group the
records by year and then place a sum in the group footer.

Use this is the sorting grouping options box =Year([DateField])

--
Wayne
Manchester, England.



Ronnie said:
I have a report which is based on 3 queries. I would like to add a sum to a
group of items within a year. Is there a way I can do this on the report, or
should I do this through by entering the criteria in one of the queries?
Click to expand...
Click to expand...
 
Top