| | |
|
|
|
need to delete record having two different fields with same value |
|---|
| message from L. T. Portella on 13 May 2004 |
need to delete record having two different fields with same identical value
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
|
| Brendan Reynolds replied to L. T. Portella on 13 May 2004 |
DELETE * FROM YourTable WHERE FirstField = SecondField
Am I missing something?
|
| L. T. Portella replied to Brendan Reynolds on 14 May 2004 |
Brendan
No I am sure you are not missing anything except that I just dont know how
to do it. Could you walk me through step by step. I know how to set a query
but when you say "delete * from your table where firstfield = secondfield" I
would not know where to start. Thank you for your time
"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message
news:uIyJtVNOEHA.2524@TK2MSFTNGP11.phx.gbl...
|
| Brendan Reynolds replied to L. T. Portella on 14 May 2004 |
Start by creating an ordinary select query, and specify the criteria, e.g.
in the criteria row of your "firstfield" column the expression would look
like =[secondfield]. Switch to datasheet view to make sure that it displays
only the records you want to delete. Then go back into design view and
choose Delete Query from the Query menu.
|
|
Archived message: need to delete record having two different fields with same value (MS Access)
