Query that equivalent to UNION query

  • Thread starter Thread starter Boon
  • Start date Start date
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
 
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

Union Query to list duplicates 2
SUM in a UNION query 2
Union query 5
Union Query 2
Run Make Table Query on Union Query 2
Union Query and Field Alias 7
Duplicates in union query 3
union query problem 16

Back
Top