I have a linked table (tblProofCycle) that I'd like to run through a query to create a new table.
The table contains the following fields: Order, Desc, dtDate, dtHour, dtMin. The new table (tblProofs) contains the same fields.
Each activity of an order is recorded in the linked table. I'd like to delete all instances of an order if one of it's Description values is "Customer".
Here's an example:
Order DESC DTDATE DTHOUR DTMINUTE
101243769 6/1/2010 6 29
101243769 Customer 6/1/2010 8 1
101243769 6/1/2010 8 1
101243770 6/1/2010 6 32
101243773 6/1/2010 6 35
Using the above example, I need to remove all records for Order 101243769 because one of them contains "Customer".
Can this be done with a delete query?