COMPARE THE TWO TABLES

R

Rick

PLEASE HELP!!!

I HAVE TWO TABLES WITH THE SAME FIELDS, BUT TWO DIFFERENT
SOURCES. ONE IS MY BROTHER'S ADDRESS BOOK AND ONE IS MY
MOTHER'S BOTH TABLES HAVE OVER 10000 RECORDS IN THEM. THE
FIELDS ARE SOURCE, NAME, ADDRESS, CITY, STATE, ZIP AND
PHONE NUMBER

I WOULD LIKE TO COMPARE THE TWO TABLES BY LINKING THEM
TOGETHER AND LIST THE DIFFENCS IN RECORDS, IN THE ADDRESS
FIELD. EXAMPLE IF MY BROTHER HAD 600 WHITEHOUSE ROAD AND
THE OTHER ONE DID NOT LIST THAT AND IF THE OTHER TABLE HAD
10 UNITED NATION ROAD LIST THAT RECORD OUT

I DO KNOW I HAVE TO LINK THE TWO TABLES TOGETHER, BUT THAT
IS ALL I KNOW. CAN YOU HELP ME WITH SETING THIS DATABASE
UP AND THE CRITERIA?

A BEGININGER
[email protected]
 
M

MacDermott

Welcome to the wonderful world of newsgroups.
As an Access beginner, I'm assuming that you're also a beginner here, and
may not realize that posting in all caps is considered shouting - something
to be avoided.

I think your problem can be addressed by using Access's "Unmatched Records"
query wizard.
From the database window, click Query - New, then select "Unmatched Records
Query".
The wizard should guide you through the rest.

HTH
- Turtle
 
Top