ComboBox/List Box Sums in Reports

  • Thread starter Thread starter Cari
  • Start date Start date
C

Cari

I am working with a List Box, what I am trying to acheive in my report is to
have a Sum of Each item in my List Box....not just a grand total. I also need
to have the Sum listed with the item.
Example.....list box 1 Health & Safety
2 Initial Visit/New Provider
3 Curriculum Training
My Report will sum as "6" I need it to Sum Health & Safety = ? Initial
Visit/New Provider= ? Curriculum Training=?....etc. I hope this makes sense.
I am sure it can be broke down this way but I have never had ANY training
other than trial and error. PLEASE HELP!!! Oh, I am working in Access
2003. Thank you :)
 
If you want to display group totals together in a report that also contains
the group totals separately, you may need to use a subreport based on a
totals query.

Group A
3
5
1
Total Group A 9
Group B
6
1
Total Group B 7
=== subreport in main report ====
Group A 9
Group B 7
========================
 
Back
Top