rport and a few queries

[Jean-Paul]

Hi,
When I create a report and I use the wizard I am asked to enter the
query or table it will be based on.

However.. I want a report displaying data based upon more then one query.

Is this possible and if so, how?

Thanks

 

[Marshall Barton]

When I create a report and I use the wizard I am asked to enter the
query or table it will be based on.

However.. I want a report displaying data based upon more then one query.

Not possible. You need to figure out the relationship
between the three queries:

If they are related one-to-many, then Join the base queries
in a a fouth query for the report.

If the three queries all return the same fields )probably
filtered differently. Then maybe you want the fourth query
to Union the other three.

If your three queries are unrelated and you just want the
unconnected data to appear in one printout, then create a
separate report for each query and use these reports as
subreports in an unbound main report.