Parameter Query Using a Date Field

D

DAngelia

I would like to write a parameter query on a date field (birthdate).

I would like the parameter to ask me what month I want to result and get
only the month requested.

For example: if I answer the question with 01 for Jan I do not want to see
10 for Oct or 11 for Nov?

Help!!!
 
J

Jeff Boyce

If you want to be prompted for the "month" of the date, you'd have to be
prompting in a field that holds the "month" of the date, not the date.

Try creating a new field in your query, something like:
MonthOfBirthdate: Month([YourBirthdateField])

Now put your parameter prompt under THAT field.

Regards

Jeff Boyce
<Office/Access MVP>
 
D

DAngelia

Thank you for such a speedy response.
It worked!!!!
--
Thanks
D''''Angelia


Jeff Boyce said:
If you want to be prompted for the "month" of the date, you'd have to be
prompting in a field that holds the "month" of the date, not the date.

Try creating a new field in your query, something like:
MonthOfBirthdate: Month([YourBirthdateField])

Now put your parameter prompt under THAT field.

Regards

Jeff Boyce
<Office/Access MVP>
Click to expand...
 
Top