How Can I join Two Queries?

[alex]

I have two queries that have similar information that I want to combine into
only one query or file so I can use in a report. I have tried several queries
to combine that information but nothing has worked so far. Does anyone know
how I can combine both queries into only one? (basically I want Query 1 &
Query 2 to join and become one master query with all the information)

 

[KARL DEWEY]

I think you want a UNION query.

 

[alex]

Great thank you for the tip, but how can I do this using a UNION query? Can
you give me an example on the correct format to use with the fields below.

TABLE A TABLE B

Item# Item#
Description Description
Price Price

 

[KARL DEWEY]

SELECT [Item#], Description, Price
FROM [Table A]
UNION ALL SELECT [Item#], Description, Price
FROM [Table B];