|
| 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
October 24th, 2009, 06:48 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
October 24th, 2009, 11:12 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
