Highlighting records in a query

[Karl]

I have a database which records service returns. I need to highlight a record in red if the field called "in progress" (the date a job is started) is null, and the current date is more than 10 days after the date entered in the field "Date R'ecd" (the date the unit was booked in. ie, I want to easily identify any jobs which have been ignored for more than 10 days

Can anybody help?

 

[Duane Hookom]

This can't be done in a table or query. You would need to use Conditional
Formatting in a form.

--
Duane Hookom
MS Access MVP

I have a database which records service returns. I need to highlight a

record in red if the field called "in progress" (the date a job is started)
is null, and the current date is more than 10 days after the date entered in
the field "Date R'ecd" (the date the unit was booked in. ie, I want to
easily identify any jobs which have been ignored for more than 10 days.