How to compare two tables in Access 2000?
 

Hello All!
I need some help with comparing tables in MS Access 2000.

There are two tables with exactly the same fields.
One table may contain more records than the other and vice versa.

I need to compare two tables in a database and filter out the records that
are mismatching and export it in a new table.

I also need to create a new table with all the records that are in table 1
but not in table 2, and another table with records which are in table 2 but
not in table 1.

I'm novice to Access and i'm not into programming..so i would like to know
if a standard code/ template that is already available to perform this
function..?

Any inputs on this will be highly appreciated!
Thanks
Futureer

Hi

I suggest you repost this in an Access newsgroup!

--
Andy.


"Futureer" wrote in message
...
Hello All!
I need some help with comparing tables in MS Access 2000.

There are two tables with exactly the same fields.
One table may contain more records than the other and vice versa.

I need to compare two tables in a database and filter out the records that
are mismatching and export it in a new table.

I also need to create a new table with all the records that are in table 1
but not in table 2, and another table with records which are in table 2
but
not in table 1.

I'm novice to Access and i'm not into programming..so i would like to know
if a standard code/ template that is already available to perform this
function..?

Any inputs on this will be highly appreciated!
Thanks
Futureer