querying database for certification expiration 30, 60, & 90 days o

[Solomon]

I'm currently using access 2002. I have a large database with EMT and
Paramedic certifications (e.g. CPR, ALS, Recerts etc) and their expiration
dates. I would like to develop a query or system where I'm alerted when a EMT
or Paramedic's certification is about to expire. Also, I would like to be
alerted at 90, 60, & 30 days from the actual expiration date. Thank you

 

[Wayne-I-M]

Hi

There are so many way to do this - you may not get a good answer without
more details.
Where are you go ing to use it. Form Query report etc

eg
You could use a simple nested IIF
IIf(DateDiff("d",[TableName]![NameOfField],Date())<90,"Warning - less than
90 days to go", something else here)

You could use a make table query - this would be a good idea so that you
could be warned then do "something" (click a button etc) to show you have
actioned the warning - this would than store your "click" Now() and cancel
futre warnings

etc
etc

you need to give more details about you want to warning to do and where it
will warn

 

[Solomon]

Thank you Wayne for your response. I like the second option best. I guess
"alert me" was a misleading phrase. I would like to be able to click a button
(lets label the button "90 days") and the names, type of certification (thats
due to expire), and other select information (e.g. employee #, contact info,
etc...) of the EMTs and Paramedics whose certification(s) will expire within
the 90 days will be outputed in a spreadsheet. Similarly, for 30 and 60 days

Hi

There are so many way to do this - you may not get a good answer without
more details.
Where are you go ing to use it. Form Query report etc

eg
You could use a simple nested IIF
IIf(DateDiff("d",[TableName]![NameOfField],Date())<90,"Warning - less than
90 days to go", something else here)

You could use a make table query - this would be a good idea so that you
could be warned then do "something" (click a button etc) to show you have
actioned the warning - this would than store your "click" Now() and cancel
futre warnings

etc
etc

you need to give more details about you want to warning to do and where it
will warn

--
Wayne
Manchester, England.

I'm currently using access 2002. I have a large database with EMT and
Paramedic certifications (e.g. CPR, ALS, Recerts etc) and their expiration
dates. I would like to develop a query or system where I'm alerted when a EMT
or Paramedic's certification is about to expire. Also, I would like to be
alerted at 90, 60, & 30 days from the actual expiration date. Thank you