newbie question: query only the records are in current month

[cuongvt]

I've tried out in query's criteria of date filed: "month(now())", but it not works.
Could you guide me how to query only the records of current month?
For example:
In case of this month: I only want the record for August. But in case of next month, I only want the records for September.
many thanks. I need your help.

 

[Navyguy]

Hit there cuongvt

Now() means right now...according to your internal clock of your system. This included both the day month year, hours minutes and seconds.

I suggest using a filter that just looks for the month only.

Also not sure what your fields look like but Date is a reserved word in access and may cause you some problems in the future. You should use names like:BirthDate, DelDate, PurchaseDate, RegistrationDate, etc.

Hope this helps.

 

[cuongvt]

thank you,
but I found the solution:
use: dateadd("m",-1,date()) in criteria of date field.
thanks anyway.

 

[Mile-O]

That will only give you one day's worth of records.

 

[AN60]

Try this, it works for me;

Between DateSerial(Year(Date()), Month(Date()), 1) And Date()