create report totals from ms access

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

Guest

Hello,

I have a table with three columns. Column one is country, column two is Cat
1 (values A, B, C or D), column three is Cat 2 (values E, F, G, or H). I
would like to count the totals and display in two custom report format as
follows:

DB data
Country Cat 1 Cat 2
Italy B H
Italy D E
Italy A H
etc.

Reports

Rpt1
Country <Total A's> <Total B's> <Total C's> <Total D's> <Total All>

Rpt2
Country <Total E's> <Total F's> <Total G's> <Total H's> <Total All>

Thanks for the help.

Bob
 
Create a totals query that groups by Country & Cat 1 and counts Cat 1. Use
this query as the record source for Rpt1. Do something similar for Cat 2.
 
Duane, thanks for your response. I understand what you are saying but I am
not Access savvy. Could you provide an example of the totals query by group
using what I've provided?

Regards,

Bob
 
While in the design view of your query, click View-Totals. This will create
another row in the grid with a label on the left of "Total:". This is where
you can specify Group By or Count or many other aggregates.

After saving your query, you can use it as the Record Source for your report.
 
Back
Top