vb.net - My data type in MS Access is Date and Time my error is mis match data type -


my data type in database date/time

my error data type mis match

please tnx...

            dim try3 string             cmd1 = "select count(new) cnew sheet empname =  '" & try3 & "' , new not null"             cmd2 = "select count(rev1) crev1 sheet empname =  '" & try3 & "' , rev1 <> '" & try2 & "' "             cmd3 = "select count(rev2) crev2 sheet empname =  '" & try3 & "' , rev2 <> '" & try2 & "' "             cmd4 = "select count(rev3) crev3 sheet empname =  '" & try3 & "' , rev3 <> '" & try2 & "' "             cmd5 = "select count(rev4) crev4 sheet empname =  '" & try3 & "' , rev4 <> '" & try2 & "' "             cmd6 = "select count(rev5) crev5 sheet empname = '" & try3 & "' , rev5 <> '" & try2 & "' " 

if try2 date variable, should read:

and rev1 <> #" & try2.tostring("yyyy'/'mm'/'dd") & "# " 

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -