Parameter query for only the month on the date field.

  • Thread starter Thread starter jess
  • Start date Start date
J

jess

I have a field that contains birthdays. I want to be able
to use a parameter that will prompt for the month only on
that date field. Such as month 1 through 12.
I was using a function that will retreives only the month
but it retreives the current month.
Month([DateBirth])=Month(Now)
 
Month([DateBirth]) = [What Month (1-12)?] will prompt the user with the
phrase between the [].
 
I have a field that contains birthdays. I want to be able
to use a parameter that will prompt for the month only on
that date field. Such as month 1 through 12.
I was using a function that will retreives only the month
but it retreives the current month.
Month([DateBirth])=Month(Now)
Click to expand...

As criteria for the query:
Where Month([DateBirth]) = [Enter Month Number]
 
Back
Top