report counts

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

Guest

I imported in excess of 10,000 employee records into an access table. I'm
trying to create a report against that table that prints counts by
department. I don't need to print the detail. I need to count the total
within the Department and I need to count by those who have certain criteria
in a specific field.
 
Hi Duane

Right now when I print preview, I see all 10, 000 plus records. I only want
counts by department and counts by company to print on the report. I'm
trying to understand how to create a summary report versus a detailed report.
I'm new to ACCESS if that helps you undersand why I wasn't clear on my first
question and may be confusing you even more now--
vickilynn
 
If I understand you correctly, you could create two Totals queries Each
would need only two fields, the field that you want to count (like CustID)
and a groupby column for dept or company. Then create a report with one
query as its recordsource; create another report based on the other query,
then use that second report as a subreport of the first. You now have one
report showing ??counts by department and also company.
-Ed
 
Thanks Ed,

Your reply was the exact explanation I was looking for. I'm new to "Access"
but very proficient on main frame report writing, which is a little more
structured than "Access". I think I will adjust well with the support I've
received thus far from Office Discussion Groups. Thanks again!!
 
Back
Top