combining more than one table with the same fields in MS Access 20

J

Joe G

I've searched for similar questions and couldn't find one. I know I've done
this before but can't remember whether I used a make query or macro within MS
Access. Could someone please help me with this? Thank you in advance!!
Regards,
JAG
 
J

Joe G

Hi Karl,
Thanks for the quick response. I can't find Union as an option in the drop
down when selecting a query type. Where do I find that?
 
D

Douglas J. Steele

Unfortunately, the graphical query builder doesn't support UNION queries.
You need to go into the SQL View and work directly with the SQL.
 
Top