Hi all,

I have this bit of SQL that I can't get working.

rst1.Open "SELECT Studenten.* FROM Studenten WHERE (((Studenten.Printen) Is Null) AND ((Studenten.VerzendenNaar) Is S));"

I know the first part is proper untill ....((Studenten.VerzendenNaar) Is S));" is proper but I can't seem to get the end right. If the field VerzendenNaar in the table Studenten has an S in it I wan't it to select it.
Pretty please with suggar on top tell me what I am doning wrong. (Probably simple as pie)

Thank you all and have a nice easter!

Jasper