Flagging a date that is overdue

A

Alert3FF

Greetings,
Is there a way to do this?
An expiration date compared to today's date.
If the expiration date has passed generate a overdue statement like "Yes" or
something.
Thanks,
Ed
 
D

Douglas J. Steele

One way would be to add a computed field to the query that the report's
based on that calculates the flag:

Overdue: IIf([ExpirationDate] <= Date(), "Yes", "")
 
Top