Flag particular dates

[Steve]

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.

[John Welch]

Re: Flag particular dates

you can use the datediff function:
datediff("w", now(),ExpDate)
will tell you the number of weeks between todays date and the expiration
date. If you want to see all records where this is less than or equal to 4,
you can put this in the criteria for the ExpDate field in a query
datediff("w", now(),ExpDate) <= 4
or you could say
datediff("w", now(),ExpDate) <= [enter number of weeks]
and it will ask you each time you run the query how many weeks you are
interested in.
for more info, look at datediff function in visual basic help. If you don't
know how to get to vb help, click on modules, in main db window, then say
new and then you should get a menu that has help.
hope this helps

"Steve" <slp@e-access.com.au> wrote in message
news:e81qis$iv$ 1@news-01.bur.connect. com.au...[color=blue]
>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.
>[/color]

[BillCo]

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 [MedicalExipryDa te] <
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:[color=blue]
> 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.[/color]