Request help with Delete Queries

[Guest]

1) I have made a select query on a table that shows all records.
2) I can change the select query to a delete query. I execute the query and
records are deleted.
3) I repopulate the table.
4) I add a second table to the query. This table is joined to the 1st as a
way to limit the records to delete (show only records where fields are equal.)
5) When I preview the records to be deleted the display is correct.
However, when I attempt to execute the query I am told that it is unable to
delete records from the table.

For some reason, Office help doesn't seem to have much (if anything) on
Delete Queries. Any suggestions?

Thanks

 

[Guest]

No need to reply. I found out about the "select distinct rows" property for
the delete query and now it seems to work.