Linking with dates

[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

 

[John Vinson]

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

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.