annual birthdate for the current month

[ياسر]

i want to get the employee's birthdate using query to manage report to
display the emplyee's birthdate for every month
example:
the report like this
the employee's that have birthdate for this month:
empname - birthdate
i made query to report the birthdates
but i want to let the query show only the employee's that there birthdate is
for the current month
so please how to do this

 

[Allen Browne]

Create a query.

Type an expression like this into the Field row:
TheMonth: Month([DOB])
substituting your field name for DOB.

In the next column:
TheDay: Day([DOB])

You can now create a report by month and day (without the year.)

Add any criteria you want. For example, under TheMonth:
((Month(Date()) - 1) Mod 12) + 1