query for records this month

[Spencer Hutton]

i am an access newbie. i need help with a function in a query. i want to
create a function that will return only the records created this month. the
date field is called 'StartDate'. so i want only records whose 'StartDate'
value falls in the current month. TIA.

 

[Wayne Morgan]

For the criteria in the StartDate field try:

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

The 0 in the second part is really 1 - 1. What we are doing is finding the
first day of next month (Month + 1) and subtracting 1 day.