Display this month's birthday(s)

[chellebell1689]

Hello,
I've got a attendance roster that we generate at the beginning of each month, and I filter by class. My pastor wants to display those who have a birthday during the current month. How would I show the birthday ONLY if it occurs during the current month?

I tried making it a criteria in the query, but then it would only show those meeting the criteria. I just want it to show everyone in the class and then only show the birthday field if their birthday is occurring this month.

Let me know if I need to explain better. Thanks in advance.

 

[plog]

You didn't provide the field name of your birthdate field, so let's say its called [DOB]. You can do this in the query by adding a field like this:

BirthdateShown: Iif(Month([DOB])=Month(Date()), DOB)

Then just add the BirthdateShown field to your report.

 

[chellebell1689]

Ok, I typed exactly what you have in the "Field" box in the query builder for my report. When I try to generate the report (or hit "report view") it asks for the "birthday" parameter. (Birthday is the name of the field) I did add the birthday field from the table, do I need to add the table name to the expression you wrote?

**EDIT**
I attached a picture of my query builder incase that might help.

 

[chellebell1689]

NM! I got it! I just went in and deleted the "birthday" i typed and double clicked the "birthday" field name in the expression builder! Thanks so much for the help!