1. Is either table part of a database?
JCT- THE TABLE BEING COMPARED AGAINST IS PART OF A DATABASE. THE OTHER IS A FREE TABLE
2. Is one table much larger than the other?
JCT - THE TABLE BEIGN COMPARED AGAINST STARTS OFF BEING LARGER BUT AS THE MONTHS GO BY THEY EVENTUALLY EVEN OUT...THE TABLE THAT I'M COMPARED IS A CUMULATIVE TABLE THAT ADDS TO MONTH BY MONTH
3. What do you intend to do with the duplicates?
JCT - I WANT TO DELETE THE DUPLICATES AND DO NOTHING WITH THEM. ONLY IF THE RECORDS ARE NOT DUPLICATE (AT LEAST ONE FIELD IS DIFF) BETWEEN THE TWO TABLES, THEN I WILL REPORT THOSE
4. How many fields are there?
JCT - THERE ARE 32 FIELDS
Thanks in Advance.
J. Turner