How to select records by month by using a pop up?

  • Thread starter Thread starter meisaka
  • Start date Start date
M

meisaka

I am trying to create a query with a pop up dialog box for
the users to enter the month they want to view.
I know there is a format that I can write under the Field
section, please help. Thank you.
 
I am trying to create a query with a pop up dialog box for
the users to enter the month they want to view.
I know there is a format that I can write under the Field
section, please help. Thank you.
Click to expand...

Put

[Enter month:]

with the square brackets on the Criteria line.

If it's a Date/Time field, you will need a bit more work - try a
criterion of
= DateSerial(Year(Date()), [Enter month number:], 1) AND < DateSerial(Year(Date()), [Enter month number:] + 1, 1)
Click to expand...
 
Back
Top