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
 
Back
Top