If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
expiry dates reminder
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 |
#2
|
|||
|
|||
expiry dates reminder
On Sat, 24 Oct 2009 10:48:55 -0700 (PDT), Tia
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|