report from multiple queries/tables

[soulpiercing]

I am getting down to putting my reports together but I need to pull information from several queries/tables. Previously I had the queries export to Word then pull into a document but this is not very user friendly. I want to pull a report like this:

HEADER
______

query 1 report info

______

query 2 report info

_____

query 3 report info

_____

etc.


Any ideas are welcome

Jason

 

[soulpiercing]

another thought

Could I do this through mail merge? Then have a button to open the MS Word doc from the directory and use the data in Access to generate the report?

 

[Rich]

Either use a Union Query to combine the data for one report or use sub reports for each query