Delete Query

[GeoDude]

I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.

 

[Dirk Goldgar]

I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.

Please post the SQL of the query.

 

[John Vinson]

I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.

Yes... but not all queries are updateable, and unless the query is
updateable it will in fact give this message.

You will need a unique Key, such as a Primary Key, on the combination
of the three fields.

Perhaps you could open the query in SQL view and post the SQL text
here; someone may be able to suggest an alternative query that will
work.

John W. Vinson[MVP]