expired data

  • Thread starter Thread starter fapa via AccessMonster.com
  • Start date Start date
F

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?
 
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.
 
Back
Top