Re: Flag particular dates


fly me to oz and throw in a few lessons and i'll build the whole thing
for you ;)

seriously though - how you flag them really depends on what you want to
do. Probably the easiest solution would be to create a report lising
everyones details and put in a filter saying [MedicalExipryDate] <
date() + 28
Then just print the report every day, or on a weekly basis.

Other more complex solutions that you could use would be an automated
email, message box alerts on screen, or actually changing the data to
add a "flag" to the record, or even auto-printing a reminder letter to
your printer (via word). It really depends on your setup and what you
want to achieve.

Steve wrote:
I have set up a db at work, I work in a flying school. All students and
other pilots are included in this db, along with particulars such as Medical
Certificate expiry date. I need to have the db 'flag' those people whos
medical certificates will expire in say, 4 weeks time. Any help in setting
this up would be appreciated, or perhaps if there are any publications I
could buy, I would appreciate the information. Location: Adelaide, South
Australia.

.