expiry dates reminder


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
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expiry dates query 1
pop up reminder vba 1
11 months for expiry 1
expiry dates report 2
VBA coding for expiry dates alert threw email 1
Access Microsoft Access Calculated Field - Expiry Date 0
Email Reminders 7
Data Entry Form. 3

Top