jpkelly

Worked perfectly, thanks so much. Another little thing that I've learned.

JPEG attached, hope this helps! JK

Hello, New at this DELETE thing. I wish to write a DELETE query that will remove records from the 'REPAIRS" table. The conditions that must be met is that the "active" field = false in the "REPAIRS" table and that the "tradeID" field in the "REPAIRTRADE" table = cet. I'm confused about the statement needed and the syntax. Any help is truly appreciated.