Multiple Queries in One Data Sheet....

  • Thread starter Thread starter Muse
  • Start date Start date
M

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.
 
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
 
Back
Top