filtering duplicate records

[Ryker7]

I have a database that has employee records. In some instances, there are duplicate records in the database that are an integral part. I want a report to list the employee records but not the duplicates. How do I construct the query to only print the duplicate records once?

 

[scriverb]

If the duplicate records are completely duplicate in all fields you can create a SELECT query with all fields being selected. Then use the Totals button to Group By on all fields. This will group all of the duplicated records into one record. The single records will remain as one.

EXAMPLE:

Select A.Field1, A.Field2, A.Field3, A.Field4 
FROM Table1 as A 
GROUP BY A.Field1, A.Field2, A.Field3, A.Field4;

Response back if you have any questions.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]