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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top