expiry dates report

T

Tia

Hello,
I have a list of exiry dates for the employees with different dates,
how can i generate a report that gives me the expiry dates of this
month only

Thank you in advance
 
K

Klatuu

Use a query as the reports record source that filters the records based on
the exipery date:

WHERE Format([ExpireyDate], "yyyy/mm") = Format(Date(), "yyyy/mm")
 
Top