deleting records - in a duplicate query

[Guest]

hi,

have a table (ill call table 1) which contains some duplicate records, i
want to be able to delete these records. i have created a query that finds
the duplicate entries, i need to be able to delete these records from the
table OR move them into another table (duplicates table 1) . i have tried to
delete them in the datasheet view of the duplicate query - but get a "record
not deleted - data is read only" msg appearing, although i am sure that the
readonly and permissions are ok.

any help greatly appreciated

andrew dw

 

[Tom Ellison]

Dear Andrew:

You have some duplicates, and you want to delete them.

By duplicate, do you mean you have two rows in a table that are exactly
identical in every column, or only some columns?

By delete them, do you mean remove all of the, or all but one?

If you want to delete all but one, and they are not all exactly identical,
which one do you want to retain? Or does it matter to you which is kept.

The answers to these questions make a large difference in how this is done
and the kind of results you will obtain.

Tom Ellison

 

[Guest]

i want to delete multiple phone numbers from a column and leave jus one of
the numbers, how can i do it

Dear Andrew:

You have some duplicates, and you want to delete them.

By duplicate, do you mean you have two rows in a table that are exactly
identical in every column, or only some columns?

By delete them, do you mean remove all of the, or all but one?

If you want to delete all but one, and they are not all exactly identical,
which one do you want to retain? Or does it matter to you which is kept.

The answers to these questions make a large difference in how this is done
and the kind of results you will obtain.

Tom Ellison

 

[Tom Ellison]

Dear Adnrew:

My previous questions have gone unanswered. If you cannot explain, could
you give an example?

Tom Ellison

i want to delete multiple phone numbers from a column and leave jus one of
the numbers, how can i do it