expiry dates reminder

  • Thread starter Thread starter Tia
  • Start date Start date
T

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
 
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
Click to expand...

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)
Click to expand...

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.
 
Back
Top