Need Help with Date Query

  • Thread starter Thread starter Tom Kreikemeier
  • Start date Start date
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
 
Not sure how you set up the DateField in our database but try:

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