Hi
Have been sent a table which is quirky in searches. I found by running the duplicate query that I have 1400 duplicate records.
A search on google tells me to visit each one and right click & delete.
I looked up select distinct and tried to set it up to select all records except those that had identical fields :
Forename
Surname
FullDateOfBurial
The table has fields:
BurialID
ChurchID_fk
Ficheref
Forename
SUrname
Abode
DateofBurial
YearOfBurial
FullDateOfBurial
Nptes
Age
CeremonyPerformedBY
PageNo
EntryNO
but got in a terrible mess and had to restore my backup.
Am I approaching this the wrong way?
I thought use select distinct to list all records in aquery -then use the make table option then delete the original and rename the new one.
thanks
Ian