By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Automatically flagging a date T+30 days

P: 6
I have a simple database in Access which tracks employee information. These employees require regular security processing to continue working.
I have dates recorded for their last security screening, I need to flag or have an automatic prompt to inform the end user when we are 30 days out from the next screening due date.
Any suggestions for this rookie user?
Thanks.
Oct 17 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Do you want to produce a monthly report showing all employees due to be screened within the next 60 days.

Base the report on a query. This query assumes 1 year between screenings

SELECT field1, field2, field3, LastScreeningDate, etc
FROM TableName
WHERE ([LastScreeningDate]+365) BETWEEN Date() And Date()+60;


I have a simple database in Access which tracks employee information. These employees require regular security processing to continue working.
I have dates recorded for their last security screening, I need to flag or have an automatic prompt to inform the end user when we are 30 days out from the next screening due date.
Any suggestions for this rookie user?
Thanks.
Oct 17 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.