Multiple Queries in One Data Sheet....

[Muse]

Is there a way to display multiple queries in one datasheet. I have multiple
crosstab queries that I want to display in a single view. Tried doing a macro
but when I call each query it opens up in a different window. I need each to
run and display as if it were a single report.

 

[John Spencer MVP]

IF the results of all the queries were identically structured you could use a
UNION query to combine the results.

Or if there was a primary key (or a unique field) that you could join on, then
you could have a horizontal row of up to 255 fields to display the data. Of
course that would mean you need all the values for said field to appear in
each of the queries.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County