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
|
|||
|
|||
Adding a second summary field/page?/Merging summary report
Hi, I am using Access 2002 and I need some help on my report. I have a report that shows a summary of completed audits by Auditors and the type of audit. I use a footer called Completed to get all the completed audits by auditor. I can make a completed summary by Auditor and get the total number of audits done (see below). Now I have another report that will show the opposite. I have a footer that I called Uncompleted that shows a summary of audits not completed by Auditors and the type of audit (see below). I can make a summary of not completed audits by Auditor and get the total number of audits pending. Basicly I have two different report summary. What I like to do is to have both summary in one page. I would like to have something similar below. I want to show the Completed Audits by Auditors with a total and below that a summary of Audits Not Completed by auditors and a total. How can I do this? Can someone point to me the right direction or a web site for an example or a book. Any tips will be appreciated. Thank you in advance. Completed Audits Auditor Audit Type - AB Completed CAM 3 Yes AMM 4 Yes JLJ 3 Yes Total 10 Audits Not Completed Auditor Audit Type Completed CAM 5 No AMM 4 No JLJ 1 No AM 5 No Total 15 |
#2
|
|||
|
|||
Alex Martinez wrote:
I am using Access 2002 and I need some help on my report. I have a report that shows a summary of completed audits by Auditors and the type of audit. I use a footer called Completed to get all the completed audits by auditor. I can make a completed summary by Auditor and get the total number of audits done (see below). Now I have another report that will show the opposite. I have a footer that I called Uncompleted that shows a summary of audits not completed by Auditors and the type of audit (see below). I can make a summary of not completed audits by Auditor and get the total number of audits pending. Basicly I have two different report summary. What I like to do is to have both summary in one page. I would like to have something similar below. I want to show the Completed Audits by Auditors with a total and below that a summary of Audits Not Completed by auditors and a total. How can I do this? Can someone point to me the right direction or a web site for an example or a book. Any tips will be appreciated. Thank you in advance. Completed Audits Auditor Audit Type - AB Completed CAM 3 Yes AMM 4 Yes JLJ 3 Yes Total 10 Audits Not Completed Auditor Audit Type Completed CAM 5 No AMM 4 No JLJ 1 No AM 5 No Total 15 Not entirely sure what your data looks like, but it seems like you can do all this in one report by creating a group on the Completed field and another group on the AuditType field and specifying the appropriate Header and Footer sections. If you're not familiar with groups, you can specify them using the View - Sorting and Grouping menu item. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding summaries, rows and pre-population | JFH | New Users | 1 | May 24th, 2005 08:52 PM |
Linking References from Multiple Sheets to One Summary Sheet | Kim | Setting up and Configuration | 3 | May 5th, 2005 04:56 PM |
Adding rows of different info from separate worksheets into summar | Barry P | New Users | 1 | February 8th, 2005 02:47 PM |
Updates to data based on a query (adding spaces before the data) | confusedPM | Setting Up & Running Reports | 5 | October 21st, 2004 08:21 PM |
multple sheet references in a summary sheet | meesh1224 | General Discussion | 2 | June 18th, 2004 02:15 PM |