Duplicate Records

[sg]

Hi,

I was trying to create a primary key, always complains that duplicate value
is going to be created. I don't think my data has duplicate records. Because
it is a huge file, how can I find out. And also I use at least 4 field to
create the primary key, each of them is duplicated in the data, but after
combining them together as a key, one record is supposed to be unique. I'm
really lost here. Please help.

Thanks in advance,

Sarah

 

[Duane Hookom]

Create a totals query that groups by your 4 fields and counts the number of
records. Set the criteria under the count column to:

 

[sg]

Thanks, it works great.
Sarah

Create a totals query that groups by your 4 fields and counts the number
of records. Set the criteria under the count column to: