Can reports be based on more than one query?

[sjh]

In Access, can reports be based on more than one query or table?

If it's possible, how can I refer to the second query in the report? I tried doing that, but I get &quot;The Microsoft Jet database engine does not recognize <name> as a valid field name or expression. (Error 3070)&quot; error message.

Thanks! - sjh

 

[fredk]

Use another query to merge them together and then base the report off of this query.

Hope that makes sense.

Fred