ACCESS显示当前月份下记录的内容
如题，应该怎么在query中设置这样的criteria。
比如我有table是
2010/01/08
2010/04/15
2010/10/01
2010/10/04
我只想显示现在10月份的项目，请问应该如果设置，谢谢。
答案或建议：
找到答案了：
To include records that ...: Contain a date that belongs to the current month
Use this criterion: Year([SalesDate]) = Year(Now()) And Month([SalesDate]) = Month(Now())
Query result: Returns records for the current month. If today's date is 2/2/2006, you see records for Feb 2006.
文章来源：http://www.baikewenda.com/h/1010/a36590.html
