expiry dates reminder

[Tia]

Dear,
I'm sorry I'm new in access I hve a list of employees with birthdate
and expiry date such as passport renewal or insurance or driving
license
How can I get a report on monthly basis with all the expiry that
should be renewed for the list of employees?

Thank you in advance

 

[John W. Vinson]

Dear,
I'm sorry I'm new in access I hve a list of employees with birthdate
and expiry date such as passport renewal or insurance or driving
license
How can I get a report on monthly basis with all the expiry that
should be renewed for the list of employees?

Thank you in advance

Create a Query based on the table, with a criterion

= DateSerial(Year(Date()), Month(Date()) + 1, 1) AND < DateSerial(Year(Date()), Month(Date()) + 2, 1)

on the expiry date field to find all records expiring during the upcoming
calendar month.

Could you perhaps post the structure of your table? If you have a field for
passport expiry, and another field for insurance expiry, and so on... you've
got an improper table structure that needs reconsideration.