<div>
A union query should do it:<br />
<br />
<br />

<pre><code id="code-7946968">SELECT *
FROM tblContacts
UNION SELECT * FROM tblMoreContacts;</code></pre>
</div>


A union query should do it:




SELECT *
FROM tblContacts
UNION SELECT * FROM tblMoreContacts;

<div>
How do I ensure that Last Names are not double-counted?
</div>


How do I ensure that Last Names are not double-counted?

<div>
Union will eliminate duplicates but the duplication is based on all selected fields.<br />
If you want to base duplication just on one field then you will have to come up with some rules about how you decide which record to keep and which to remove. &nbsp;You will probably then need a second process to get the final list.
</div>


Union will eliminate duplicates but the duplication is based on all selected fields.
If you want to base duplication just on one field then you will have to come up with some rules about how you decide which record to keep and which to remove.  You will probably then need a second process to get the final list.

<div>
Thanks Peter,<br />
<br />
can you be more specific?<br />
<br />
This is exactly what I would like to do:<br />
<br />
I have [Address] and [Last Name] in both table A and B. <br />
<br />
I want to obtain a list that combines both tables where the same [Last Name] in A and B is counted only once. &nbsp;If there is a match between [Last Name] I want table A to win<br />
<br />
<br />

</div>


Thanks Peter,

can you be more specific?

This is exactly what I would like to do:

I have [Address] and [Last Name] in both table A and B.

I want to obtain a list that combines both tables where the same [Last Name] in A and B is counted only once.  If there is a match between [Last Name] I want table A to win




<div>
<div class="content wysiwyg-content">
I have 2 tables (A and B) with the same structure, what is the easiest way to obtain a list of combined record without double counting the row with the same record in a chosen field?
</div>
</div>


I have 2 tables (A and B) with the same structure, what is the easiest way to obtain a list of combined record without double counting the row with the same record in a chosen field?

table comparison in Acccess

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.