Delete Query?

[Ed]

I used the 'Find Unmatched Query Wizard' to create a qurey.
It worksd great!
I want to use that qurey results to delete the records from the table.
How do I select the table to delete from?

SELECT DISTINCTROW tblSignalsCal.SIGID
FROM tblSignalsCal LEFT JOIN qrySignalsCalculated ON tblSignalsCal.SIGID =
qrySignalsCalculated.SIGI
WHERE (((qrySignalsCalculated.SIGI)=""));

 

[Joris Dobbelsteen]

See Jet SQL Syntax.

DELETE FROM <table>
WHERE <condition>

E.g.
DELETE FROM tblSignalsCal
WHERE NOT EXISTS
(SELECT *
FROM qrySignalsCalculated
WHERE qrySignalsCalculated.SIGI = tblSignalsCal.SIGID
)

[Of course a good SQL database should understand, Access should so too]

- Joris