create report totals from ms access

[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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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.