Delete records where joined fields are equal

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

I have 2 tables, both have a field that is the same. I
ran a select query to show me the records where the joined
field is equal. I would now like to delete the records;
however, when I run the delete query I get an error
message saying I don't have permission. I am the Admin
for the database, so this is definately not the case.

Thanks!
 
I have 2 tables, both have a field that is the same. I
ran a select query to show me the records where the joined
field is equal. I would now like to delete the records;
however, when I run the delete query I get an error
message saying I don't have permission. I am the Admin
for the database, so this is definately not the case.
Click to expand...

Have you defined a Relationship between the two tables? The query will
not be updateable unless there is a unique index, such as a Primary
Key, on the joining field in the "one" side table.

Perhaps you could open the query in SQL view and post the SQL here,
and indicate from which table (or tables) you would like to delete
records.
 
Back
Top