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]
|
Similar Threads
