I have some problems with 2 kind of selects.
I want to get the records which have certain field Null. Example:
"SELECT * FROM Delivery WHERE Remark=Null"
But the compiler says: "Too few parameters, expected 1"
I am using OpenRecordset. With other queries work, like:
"SELECT * FROM Delivery WHERE SupplierCode='4578'"
I have the same problem to get records with a certain date, like:
"SELECT * FROM Delivery WHERE ArrivalDate=6/4/2004"
I know that there are records with this date. But the SELECT is not returning anything.