Need Help with Date Query

[Tom Kreikemeier]

I need a Query that gives me all the records that are
not delivered.

I get an error say's that deliverydate is a datetime
conversion error.


strsel = "select * from production where deliverydate= ' '"


Thanks,
Tom

 

[Van T. Dinh]

Not sure how you set up the DateField in our database but try:

strsel = "select * from [production] where [deliverydate] Is Null"