Duplicate Records

  • Thread starter Thread starter sg
  • Start date Start date
S

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
 
Create a totals query that groups by your 4 fields and counts the number of
records. Set the criteria under the count column to:
 
Thanks, it works great.
Sarah
Duane Hookom said:
Create a totals query that groups by your 4 fields and counts the number
of records. Set the criteria under the count column to:
Click to expand...
 
Back
Top