Multiple Counts in REport

C

Cowduek33

I'm trying to create a summary report using multiple queries and their count
values. It keeps on coming up with a #Name? error. When I tie the reprot to
a single query it works perfectly. I've used the expression builders and
seleced the countof value but it keeps on returning the error.
 
J

John W. Vinson

I'm trying to create a summary report using multiple queries and their count
values. It keeps on coming up with a #Name? error. When I tie the reprot to
a single query it works perfectly. I've used the expression builders and
seleced the countof value but it keeps on returning the error.
Click to expand...

A Report can be based only on one Query. Could you explain what these queries
are, and how you're trying to combine them? What is the "countof value"?
 
C

Cowduek33

The report is to show the breakdown or personnel per department per in the
company. The counts are the number of records in the query ( Ive got los of
queries one per department and job grade). The report I want to create would
look (with some formating like this.

Depratment

Grade X 78
Grade Y 87
etc.

any ideas?
 
G

George

I may think some ways to accomplish this:

1) Created a single query Groupped by Department, Groupped by Grade and
Count Personnel (perhaps PersonnelID), or

2) Just create a report with the above group levels.

Hope this helps

GeorgeCY

Ο χÏήστης "Cowduek33" έγγÏαψε:
 
J

John W. Vinson

The report is to show the breakdown or personnel per department per in the
company. The counts are the number of records in the query ( Ive got los of
queries one per department and job grade). The report I want to create would
look (with some formating like this.
Click to expand...

George is exactly correct. You need one (bigger) query, not a raft of little
queries! A Totals query can group by multiple fields; and you can also use the
Report's Sorting and Grouping capabilities to get subtotals and grand totals.
 
Top