Best method to join six queries

C

Chuck

Hi,

I have 6 queries that comes that I need to combine to generate a single
report. Is there any way I could accomplish using a macro and SQL? Or, would
it be better to append the data into a table?

Thanks.
 
R

Rick B

Just include them all in the record source for your report. This can either
be done by joining them (if they are related) or by using a Union query if
they all contain the same fields.
 
R

Rick B

Just an other question. Why are you pulling the data to six different
queries? This is very often needed, but could you scale this back to one
query using "and" and "or" combinations of criteria?
 
Top