report from multiple queries

[gtcom]

I would like to run a report pulling information from multiple queries. Does access allow me to do this?

 

[bkj123]

gtcom -

Not knowing more about the specifics, I would suggest combining the data into one query and then creating your report. Please provide more detail is that does not help.

Also, not sure if you wanted this question posted to the data mining forum.

- bkj123

 

[blom0344]

This is not the place for Access question perhaps, but you will find that a report addresses one table or query as a source. So , in your case the final step will be to create a query over existing queries to produce ONE recordset for the report to work upon. More sophisticated reporting tools DO offer multi-query reporting. Access reports are quite basic inthis respect.............

T. Blom
Information analyst
tbl@shimano-eu.com

 

[davidmunoz]

In any of the versions of access you can create subqueries within a report and capture information from different queries in one report.

If your pulling in same data from multiple datasources then create a union amongst them.

hope this helps!