shanedavid1981
Programmer
hey 
)
I have a table for inductees for my organisation, and agency registers are imported into this as we receive them...
The problem is that the agencies tend to send updated registers frequently, so creating duplicate entries. My system assigns unique ID numbers for each record imported too.
I have set up a select query to find duplicate records disregarding the ID number, thus getting a list of unique values that are duplicated. I now need to know how I could delete these records from the inductees table, as when i put in the ID numebrs into the query it obviously shows no data... I tried changing the query to a delete query but then it gives me all the duplicated records and the originals, so deletes data want to keep...
Can somebody help me please?
Thanks)
)I have a table for inductees for my organisation, and agency registers are imported into this as we receive them...
The problem is that the agencies tend to send updated registers frequently, so creating duplicate entries. My system assigns unique ID numbers for each record imported too.
I have set up a select query to find duplicate records disregarding the ID number, thus getting a list of unique values that are duplicated. I now need to know how I could delete these records from the inductees table, as when i put in the ID numebrs into the query it obviously shows no data... I tried changing the query to a delete query but then it gives me all the duplicated records and the originals, so deletes data want to keep...
Can somebody help me please?
Thanks
)
