Select records with date inside the current month

[Mick_Beveridge]

I have a field named 'Date' and need to run a query that selects all the records where the date value is within the current month.

Anyone know how to do this?

 

[boblarson]

First of all, if your field is indeed named Date, then rename it. Date is a reserved word in Access and it will cause you no end of grief if you continue with it.

Second, include a field in your query like:

MyMonth: Format([YourDateFieldNameHere],"mm")

in the criteria put: Format(Date(),"mm")

 

[neileg]

Bob, that will match the same month regardless of year. You'll need to include the year if you really just want the current month.

 

[Mick_Beveridge]

Thanks for the answers, the query does what I wanted