Selecting Records By Month Specified +(Year)

[Tomehb]

Ok so far i have been using Between two dates that the user enters, but
i just want the users to enter a month and year to make it more user
friendly... May some explain how i would do thhis?

 

[Tomehb]

tried somthing like this... but im too new

Month([Month]) And Year([Year])

 

[John Spencer]

Try criteria like the following

Between DateSerial([What Year],[What Month],1) and DateSerial([What
Year],[What Month]+1,0)

DateSerial takes 3 arguments, a Year, A month, and a day. The second call
adds one to the month to get the next month and then backs up one day (1-1)
to the zero day of the month, which corresponds to the last day of the prior
month.