Delete Query

[gnb621]

I have 2 tables.

April 2003 contains the following:
Product Code Warehouse Month $OH

Default contains the following:
Product Code Warehouse

I would like to delete from April 2003 all the records that match those in Default. I've never used a delete query. Can someone help me?

 

[bucsfan67]

Delete * from April 2003 where ProductCode in (select ProductCode from Default) and warehouse in (select warehouse from Default)

 

[gnb621]

When I try to run the query a window pops up to enter parameter value (ProductCode).

 

[dodge20]

It is because your table has a space in the name, and it doesn't in the query. Put brackets around it with a space, and you should be fine.

Delete * from April 2003 where [Product Code] in (select [Product Code]

Dodge20

 

[gnb621]

Thanks. That worked but now I get the following error:

Operation must use an updatable query. (Error 3073)

Never seen this before. What do I do?