Highlighting records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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


Karl said:
I have a database which records service returns. I need to highlight a
Click to expand...
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.
 
Back
Top