UNION QUERY..

  • Thread starter Thread starter Bella
  • Start date Start date
B

Bella

I made a union query using two tables which contain pretty much the same
information except one of the tables has more contacts and their information.
The union query worked great in combining the two tables but I have
duplicates for the contacts that are actually in both tables. For the union
query I used "union all" should I have used "union" only in order to exclude
any duplicates? Also is there any way of turning the results into an editable
table??
 
Use Union instead of Union All. Save the query then run another Make-Table
query using the first one as the source.
 
Hi Bella,
For the union query I used "union all" should I have used "union" only in
order to exclude any duplicates?
Yes.

Also is there any way of turning the results into an editable table??
Click to expand...

You could always base a Make Table query on your Union query, creating a
third table with the combined data. Alternatively, you can create the third
table first, and then run an append query to add records from the Union
query. If needed, you can add a new field to identify the source of the
records, ie. whether from TableA or TableB.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
I am curious why you did not just try it without the 'ALL' instead of posting
the question.
 
Back
Top