UNION QUERY..

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??
 
A

Arvin Meyer [MVP]

Use Union instead of Union All. Save the query then run another Make-Table
query using the first one as the source.
 
T

Tom Wickerath

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??

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/
__________________________________________
 
K

KARL DEWEY

I am curious why you did not just try it without the 'ALL' instead of posting
the question.
 

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