Linking with dates

  • Thread starter Thread starter Aran
  • Start date Start date
A

Aran

Is there a simple way of the database telling the user
that a date has expired, for example an item is placed on
a database and given a date, when this date arrives is
there a way getting some sort of warning message come up?
I am still new so it would have to be a relatively simple
way.

Many Thanks

Aran
 
Is there a simple way of the database telling the user
that a date has expired, for example an item is placed on
a database and given a date, when this date arrives is
there a way getting some sort of warning message come up?
I am still new so it would have to be a relatively simple
way.

Many Thanks

Aran
Click to expand...

A Query selecting records using a criterion of

< Date()

will return all records where that date field is in the past. Without
knowing more about the circumstances I'm not sure how you would use
such a query; perhaps you could use a form that starts up
automatically and displays the expired records.
 
Back
Top