The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query:

Between CDate(Month(Date()) & “/1/” & Year(Date())) And DateAdd(“m”,1,CDate(Month(Date()) & “/1/” & Year(Date())))-1

ADVERTISING
MS Access Report Generator

The criteria line above uses the “Between And” operators to calculate the first of the month and the end of the month of the current date. Enjoy!