Need Help with Date Query

T

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
 
V

Van T. Dinh

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

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