SQL="select * from mingxi where shuxing='to' and (shijian & gt;='" & amp; Search3 & amp;" 00:00:00 'and shijian & lt;='" & amp; Search4 & amp;" 23:59:59 ')
"
Shijian in the access database is time \ date format

In the search box (input) date is input YYYY - DD format, such as the 2021-4-1 - MM 2021-4-30

Then tip

The Microsoft OLE DB Provider for ODBC Drivers mistake '80040 e07'

[Microsoft] [ODBC Microsoft Access Driver] standard expression data type mismatch,

Could you tell me how to modify the statement is? Thank you

CodePudding user response:

# # 2021-04-30 00:00:00