By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

Data type mismatch in criteria expression - Microsoft Access

P: 67
Hi!

when i pass the data to my database MS-Access. i got error.

Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/Travel/Include/Update_Not_travel.asp, line 64


how i can set the value of a Date/Time column in a Microsoft Access database to an empty field value is blank ("")? pls help me..............

Thanks,
Susan.
Apr 8 '09 #1
Share this Question
Share on Google+
2 Replies


DonRayner
Expert 100+
P: 489
Since you are using a Date/Time field you can't set it to an empty string "". That is why you are getting the type mismatch, You need to set it to Null instead.
Apr 8 '09 #2

NeoPa
Expert Mod 15k+
P: 31,489
Ensure too, that the particular Date/Time field you're saving it to is configured to accept Nulls.
Apr 8 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.