 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2006report counts
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.  Signaturevickilynn And what is your specific question? SignatureDuane Hookom MS Access MVP -- >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 > And what is your specific question? > [quoted text clipped - 4 lines] > > criteria > > in a specific field. 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 > Hi Duane > [quoted text clipped - 18 lines] >> > criteria >> > in a specific field. 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!! Signaturevickilynn > 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) [quoted text clipped - 26 lines] > >> > criteria > >> > in a specific field. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.