expiry dates report

  • Thread starter Thread starter Tia
  • Start date Start date
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
 
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")
 
Back
Top