Creating a report with dates using month not year in access

[Cristina]

I am trying to create a report or something similar that will pull up our
clients birthdays, but only by month. Right now they are listing them by Year
then by month. I don't want the Year to play a factor in the report. I am
fairly new to access, so I would need a little help explaining how to do
this. Thank you!

 

[Klatuu]

WHERE Month([DOB]) = [Enter Birthday Month]

 

[Cristina]

Do I put that verbatum in the SQL view of the query? Or where would I enter
that?

If you have time, can you please give me a step by step. I have been at this
ALL day.

Thank you much!

WHERE Month([DOB]) = [Enter Birthday Month]
--
Dave Hargis, Microsoft Access MVP

I am trying to create a report or something similar that will pull up our
clients birthdays, but only by month. Right now they are listing them by Year
then by month. I don't want the Year to play a factor in the report. I am
fairly new to access, so I would need a little help explaining how to do
this. Thank you!

 

[Klatuu]

It would be the Where clause of your query.
You need to change [DOB] to the actual name of your birthday field.

This line:
[Enter Birthday Month]

will cause an input box to popup with the message "Enter Birthday Month"
If you want to pass the parameter using a control on your form it would be:
WHERE Month([DOB]) = Forms!MyFormName!DateOfBirthControlName
--
Dave Hargis, Microsoft Access MVP

Do I put that verbatum in the SQL view of the query? Or where would I enter
that?

If you have time, can you please give me a step by step. I have been at this
ALL day.

Thank you much!

WHERE Month([DOB]) = [Enter Birthday Month]
--
Dave Hargis, Microsoft Access MVP

I am trying to create a report or something similar that will pull up our
clients birthdays, but only by month. Right now they are listing them by Year
then by month. I don't want the Year to play a factor in the report. I am
fairly new to access, so I would need a little help explaining how to do
this. Thank you!