Parameter Query Using a Date Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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