Calculating Total

[Ron Kozak]

I need to show the totals for each Area. They are
grouped by Area and I need the totals of PhysicalIssues
and SoftwareIssues. Each of the issues are by a Yes/No
Data Type. I use a check box and need the count done by
boxes checked. I would like it to be display like the
following:

Area Physical Software
Big ticket 1 1
Cross Dock 0 1
Fast Track 0 1
Shipping 3 1

How can I do this?

Thanks,
Ron

 

[Marshall Barton]

I need to show the totals for each Area. They are
grouped by Area and I need the totals of PhysicalIssues
and SoftwareIssues. Each of the issues are by a Yes/No
Data Type. I use a check box and need the count done by
boxes checked. I would like it to be display like the
following:

Area Physical Software
Big ticket 1 1
Cross Dock 0 1
Fast Track 0 1
Shipping 3 1

Create a Totals query to calculate the totals. Group By the
area and Sum the Physical and Software columns. Once you
get the query returning the proper data, use it as the
record source for a simple little report. Then include that
report as a subreport in your main report.