Delete Query Problem
Posted on 2008-06-16
I'm trying to create a query that would delete a record out of a table (NeedMethodsTable) if the record's specific fields (Invoice, Item) don't exist in a different query (InvoiceItems), and also if the record entered in is not more than 1 day old
This is what i have so far, but apparently the deletition of the record only works on the 1 day old part, but not the rest.
WHERE (Exists (SELECT [InvoiceItems].INVOICE, [InvoiceItems].ITEM FROM [InvoiceItems] WHERE (
((NeedMethodTable.Complete) Is Null Or (NeedMethodTable.Complete)<>-1)
AND ([InvoiceItems]![INVOICE] <> [NeedMethodTable.INVOICE])
AND ([InvoiceItems]![ITEM] <> [NeedMethodTable.Part Number])