Sum groups in a report

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

Guest

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?
 
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])
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
How to show qry "criteria" on a report ? 10
Access Access Report Works on One Machine but not Another 3
Access MSACCESS - Sorting report based on field calculated in the report 0
Sum Group By 2
Access Report Incorrectly Summing Grouped Data 1
Sorting Problem 1
Summing groups in a report 1

Back
Top