need to delete record having two different fields with same identical value

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

L. T. Portella

daily I am given a table (access 2000) where a record may have the same
identical value in two of its fields. I have to delete such a record. Can
anyone help me with this
 
If you want to delete ALL records where
field1 = 12345 and field2 = 12345 then use

delete * from yourtable where
field1 = 12345 and field2 = 12345

If you want to delete ALL records where
field1 = X and field2 = X (any value, but the same)

Delete * from yourtable where field1 = field2

When trying delete queries ALWAYS keep a backup copy of
the original db.
 
Back
Top