Conditional date formatting (red when overdue)

[Guest]

Hi

As part of my client database I want to introduce a task list. By relating
it to the rest of the database I will be able to keep an audit trail of work
undertaken.

My question is - can I format the date in a query such that overdue (those
past their due date) tasks are highlighted in a different colour.

I have been able to sort the tasks in the query by whether they are complee
or not and in date order but I would like the extra warning of having the
overdue ones stand out.

As ever, any help gratefully received.

 

[John Spencer]

You can't do that in a query, but if you are displaying the information on a
form or printing it ina report, you can use conditional formatting to change
the color of the data.
(Conditional formatting is available in Access 2000 and later)
Use the statement
Field Value is less than Date

If you need to test another field then you will have to use something on the
lines of
Expression Is [DateOfAction] <= Date() and [Completed] = False
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..