用ACCESS存储数据，有个字段为时间型的，用的默认值是now()，要查询今年某个月的情况，SQL要怎么写呢？

[yurui]

例如，要查询3月份的情况，要怎么写呢？

[iasky]

Sql="Select Count(*) From Content where month(AddDate) = 3"

AddData是 now()

[阿_浩]

Sql="Select * From Tble where month(ddd) = 3"

[enjsky]

select * from tab_name where month(aaDate) = 11

[baikaishui_0825]

Sql="Select * From Content where month(AddDate) = 3 and year(AddDate)="&year(now())

[大圆镜智1222]

同意楼上三位所述

[ryuginka]

Sql="Select * From Content where month(AddDate) = '3' and year(AddDate)='"&year(now()) & "'"

[liuyangxuan]

or function between datetime.