Adding a second summary field/page?/Merging summary report

[Alex Martinez]

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

 

[Marshall Barton]

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.