multiple reports

[Guest]

This is a bit complicated, so please excuse me if I ramble on.
I have a requirement to generate an array of reports. These reports are to
do with an internal audit. The reports will be one of two possible formats,
depending on the product being audited. Each query may create 10 reports to
be created ( for example an audit of Product X generates 10 reports,6 of
report type A, and 4 of report type B. There is an unique identifier in the
table that highlights which report is applicable to that record ). How can I
get Access to automatically compile an array of reports with differing
numbers of reprt A and report B?

Clear?

 

[Duane Hookom]

What do you mean by "6 of report type A"? Is "A" a report or one of a group
of reports? Are all 6 the exact same report or are they different in any
way?

 

[Guest]

Thats exactly it! Depending on the type of product, the questions asked are
one of two different sets. Therefore, the final audit report may be made up
of 6 sets of report A (which are all identical other than the scores against
each question) and ssay 4 types of report B.

Many thanks for your help!

Phil

 

[Duane Hookom]

It's still a bit difficult to understand. You can use code to run multiple
reports with different where conditions. I can only assume the scores
represent only different records and not different fields.