Delete Duplicate Rwos in Ms Access

admin

Administrator
Staff member
Hi,
Could you please tell me the query to delete the duplicate rows from table in msaccess, I have 3 fields like Inspector, Region and Heading. I want to remove the duplicate record from the table with the same value of inspector and region but the heading is null.
Thanks in advance
Regds
Baby
 
Back
Top