Query Overdue Dates 1

[jchollo]

I had asked this question previously and was told to use the DateDiff() function.

I have an action database with a field Due Dates. I named another field Overdue which is currently blank with I want to use for the query results.

I want to figure out once a due date is past, have the results display in the Overdue field - 1 day past due, 2 days past due, etc. in red.

How would you write the function? I am not a Access person. Also, how could I display the query results in red?

tks

 

[PHV]

Don't store derived/calculated values in a table, especially values changing every day !
So, remove the Overdue field from your table.
In the query grid:
Overdue: IIf([Due Date]<Date(), Int(Date()-[Due Date]) & ' days past due', '')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jchollo]

When I entered the mentioned query - I received the error - You may have entered an invalid identifier or typed parentheses following the null constant criteria.

I do type this string for the criteria in the query design. pls verify.

tks