expired data

[fapa via AccessMonster.com]

Hi

i have a form that displays dates and times. When the date/time has elapsed
the current date/time, is there an expression/code that can be writen so that
the list of original dates and times does not display the expired dates and
times?

 

[Guest]

In a table, no.

In a query you would have criteria on the date field that would be something
like > Now()

For a form or report, you could use the above criteria. Of course you would
need to rerun the report or requery the form frequently. Something like that
could be done on the Timer event of the form.

 

[fapa via AccessMonster.com]

Thank you Jerry!!