Multiple Counts in REport

  • Thread starter Thread starter Cowduek33
  • Start date Start date
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.
 
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"?
 
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?
 
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" έγγÏαψε:
 
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.
 
Back
Top