Comparing 7 tables ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning, Afternoon, Evening :)

I need some help on this thing a colleague must do: compare 7 contact lists
she has in order to ensure that they are no duplicates (a contact can be
present in each of the contact list). I thought that Access was the tool for
doing this, but I am not an expert (nor a regular access user). I already
made some tests with two tables, but it becomes a nightmare for 7, especially
when considering that we need this quickly.

I guess I have to link the fiels together, but after that I don't know what
to do (with two tables, I used [distinct].[table2] to compare values between
table1 and table 2, but I don't know how to do to compare 7 tables between
them.

Thanks in advance for your help!.

Alexandre
 
I'm waiting for a post reply myself. So I hope this info may assist you and
your friend.

If possible, isolate a field in each table that is unique. Once you have the
field known, create a query to of the values of this unique field.

Using this query, you will be able to validate data for the multiple tables
by joining the unique fields to this query.

Sounds hard, but using the help you should be able to do this. Good Luck.

Also, this may help...
http://office.microsoft.com/en-us/access/HA010345581033.aspx

Cheers,

Dusty
 
Not enough detail to offer a full solution. But the best thing is probably
to combine the relevant fields in one query using a UNION query.

SELECT FieldFirstName, FieldLastName
FROM Table1
UNION
SELECT FieldFirstName, FieldLastName
FROM Table2
UNION
....
SELECT FieldFirstName, FieldLastName
FROM Table7

This will eliminate duplicates where FirstName and LastName are exactly the
same.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top