sea614

Is the ACCESS database, the record format is as follows:

2015-4-6 17:30:07
2015-7-25

sea614

Everyone remembers the ACCESS library

kanedan

Between #"&year(now)&"-"&month(dateadd("m",-1,now))&"# And #"&year(now)&"-"&month(now)&"#
Just like this format
Time query should be in the format of idea. Do not use fuzzy query of characters. It’s okay to check the month between 2 and April. It’s not very clear. Try this, if you can't, change the time
Between #2015-3# And #2015-4#

shenmue024

where datediff('m', field, '2015-03-01') = 0

kanedan

Field　Between #2015-3# And #2015-4#

51088510

"select ... where cstr(year(time field))+'-'+cstr(month(time field))='"&year(yourtime)&"-"&month(yourtime)&"'"

But it is best to use:
time_temp=year(yourtime)&"-"&month(yourtime)&"-1"
"select ... where field>=cdate('"&time_temp&"') and field<dateadd('m',cdate('"&time_temp&"'),1) "

So the index is faster

loureed

where Year(field)= and Month(field)=

xiaoyao11

Upstairs said:
The landlord overlooked a problem, that is, the format of the date converted to a string (yyyy-MM-dd, MM-dd-yyyy.....)
The correct way is:
select *
from table name
where Year (date field) = 2015 and Month (date field) = 7 and Day (date field) = 20
Use the three date functions Year, Month, and Day respectively to find the year, month, and day of the date field.

sulfuresser

Use # in the access time, such as: #2015-7-25#, this is different from the SQL database

I think:
Like, you can replace it with >,=,<This way!

若水淡淡

like'*2015-3*'