Delete Query that is dependent on values in a separate table

[mattylance]

Hello, I have a question on how to create a delete query that is dependent on the values in another table. My scenario:



TableA: Linked SQL table, no access to backend to modify or add fields. The fields are: Product, Date and Quantity.

TableB: Table that users enter values in to the one field which is also called Product.

QueryA: Want to create a delete query that will delete records from TableA. I need it to delete only if the Product value is in TableB and also utilizing criteria on the Date field ( i.e. Between [Start Date] And [End Date].

To give context, TableA is a list of products, with quantities entered by week. If the user maintains a product in TableB, when they run QueryA it will delete out any of the products from tableA that correspond.

Any help greatly appreciated.
Thanks
Matt

[ranman256]

Use the query wizard to make a FIND DUPLICATE qry.
Then examine it...just change it from select to delete.

you must use the IN sub qry method employed there. (NOT by linking tbls)

[mattylance]

Thanks for the reply. I guess I don't understand how to incorporate TableB into your response. Please advise when you have a moment.

Thanks