If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
report 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. -- vickilynn |
#2
|
|||
|
|||
report counts
And what is your specific question?
-- Duane Hookom MS Access MVP -- "Vicki Leatherberry" wrote in message ... 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. -- vickilynn |
#3
|
|||
|
|||
report counts
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 "Duane Hookom" wrote: And what is your specific question? -- Duane Hookom MS Access MVP -- "Vicki Leatherberry" wrote in message ... 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. -- vickilynn |
#4
|
|||
|
|||
report counts
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 "Vicki Leatherberry" wrote in message ... 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 "Duane Hookom" wrote: And what is your specific question? -- Duane Hookom MS Access MVP -- "Vicki Leatherberry" wrote in message ... 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. -- vickilynn |
#5
|
|||
|
|||
report counts
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!! -- vickilynn "Ed Robichaud" wrote: 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 "Vicki Leatherberry" wrote in message ... 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 "Duane Hookom" wrote: And what is your specific question? -- Duane Hookom MS Access MVP -- "Vicki Leatherberry" wrote in message ... 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. -- vickilynn |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |