Thanks Rudy, you are a wiz!
The first code worked:
Code:
SELECT Table1.siteno
FROM Table1
LEFT OUTER
JOIN Table2
ON ( Table2.siteno = Table1.siteno
AND Table2.sceno =2 )
WHERE (((Table1.sign)=Yes) AND ((Table1.age)="cur") AND ((Table2.sceno) Is Null))
Very grateful and I will take a look at your book!
Cheers
