How to Query Overdue Dates

J

jchollo

I have a field named Due Dates and also a field named Overdue which i
currently blank.

When the Due Dates is past due, I want to display in the Overdue fiel
- 1 day past due, 2 days past due, etc. in red.

How do I configure this query?

tk
 
D

Duane Hookom

You can use a query to display the number of days past due using the
DateDiff() function. You can display query results in forms and reports and
use conditional formatting to color the controls.
 
Top