Comparing records

[Weatherhelm]

Hi folks,
I am trying to get a list of unique records that exist in
one of 2 databases. The database structure is identical
in both databases and there is a common key field. I am
sure this is very basic but I can't figure out how to
program the necessary querry.

Thanks

 

[Wayne Morgan]

You will probably need to link the tables from the second database into the first in order
to run the query.

In the main database window go to the queries tab then click the New button on that tab.
Choose the Unmatched wizard. You can't get to this wizard by clicking the "Create query by
using wizard" option.

The unmatched wizard will walk you through setting up a query that will show you records
that exist in one table but not in the other.

 

[Westherhelm]

Wayne,
Thank you very much for your assistance. It worked very
well. Your prompt help was well appreciated.

Weatherhelm

-----Original Message-----
You will probably need to link the tables from the

second database into the first in order

to run the query.

In the main database window go to the queries tab then

click the New button on that tab.

Choose the Unmatched wizard. You can't get to this

wizard by clicking the "Create query by

using wizard" option.

The unmatched wizard will walk you through setting up a

query that will show you records