Selecting Records By Month Specified +(Year)

  • Thread starter Thread starter Tomehb
  • Start date Start date
T

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?
 
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.
 
Back
Top