Multiple Query results into a single table for all?

[Guest]

Hi,

I have 3 queries drawing the same data from 3 different sources, current
stock, stock in customer homes, and shipped stock (stock to dealers or
manufacturers).

All of my fields have the same names in all 3 queries.

Is it possible for me to be able to combine all 3 queries into a single
datasheet for reporting and billing purposes?

If so, how? Im really quite new at this and do not understand much
code-speak. But I get the basic how-to's if theyre in English, and use trial
and error to get the rest.

Thanks

Ed

 

[John Spencer (MVP)]

Perhaps through use of a UNION query. Probably you will want to use the UNION
ALL option.

Assuming your 3 queries are identical in structure as to the fields being
returned, it could be as simple as

SELECT *
FROM Query1
UNION ALL
SELECT *
FROM Query2
UNION ALL
SELECT *
FROM Query3

To build a UNION query, you must open a new query, and switch to the SQL view
and then type in the query.