When access performs a query, an error "Data Type mismatch in the standard expression" is thrown.

During project development, the access query operation is involved,

However, MSSQL T-SQL write more, access will also be forgotten.

In one query, it is related to the time field and is habitually written:

 

Select count (*) from [user] Where [createtime]> '2017-2-10'

 

Of course, access also habitually reports an error: "The data type in the standard expression does not match". At first, I thought my time value format was wrong. However, no errors are found after debugging,

So I began to suspect that the access SQL was correct only when I checked the access help and wrote the following sentence:

 

Select count (*) from [user] Where [createtime] >#{ 0 }#

 

This is a silly mistake to spur your carelessness!