Query that equivalent to UNION query

B

Boon

Hi,

I have two tables in exact same format. I want a query that put them into
one view. I usually use UNION query to do this. But now, I want to edit
something on them. Is there a way to add multiple tables into one query
instead of using UNION? MAKE TABLE query is one option for sure but I want
to avoid it.

Thanks,
Boon
 
J

Jeff Boyce

Before you work on this, it all starts with the data. Why do you have two
identically-formatted tables? If you were working in a spreadsheet, this
might be the main way you'd use.

What is it that's different enough that you feel you need the two tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Similar Threads

SUM in a UNION query 2
Duplicates in union query 3
Union query 5
Union Query to list duplicates 2
Union Query and Field Alias 7
Currency Format Lost in Union Query 1
How to assign table name to be value of a field in a UNION query? 2
dsum sytax error 5

Top