Display fields in different colours

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

Guest

I have a table that lists documents that need to be reviewed. It has the
following fields:
Document No
Issue Date
Due Date
Reviewer 1
Completed 1 (check list)
Reviewer 2
Completed 2 (check list)
Reviewer 3
Completed 3 (check list)
Date Comments Returned

I have a query that displays all documents that are overdue (eg the due date
is <today). What I would like is to differenciate between the people who
have reviewed and the ones that haven't when I run a report from this query.
If the completed box is checked I would like the name to be returned in green
but if the checkbox is not checked then to return the name in red. My query
only returns records where the date comments returned field is Null.
I currently do not have the completed fields used within my query. I think
I am going to have to redesign my query as well (not sure!).
Any help offered is much appreciated.
Thanks Nic
 
I wouldn't go any further without re-designing the tables to create a
Document Review table that has one record for each document for each
Reviewer.
 
Duane,

Thanks for your reply.....

I realise my table could be set up much better but I am self-taught on
access on am not sure the best way to set up this table.

Any suggestions would be greatly appreciated.
Thanks
Nic
 
Remove the reviewer and date fields from you main table and create a table:

tblDocReview
=============
[Document No]
Reviewer
CompleteDate
Sequence

You can use the Sequence field to set the order for reviewal.
 
Duane,

I have redesigned my table. I now have one table that lists the document
number, issue date, due date and comments returned to originator date. Then
I have another table that lists the document number (combo box that looks up
the previous table), reviewers name, start date and date comments returned.

I have a report that displays all the documents (grouped by document number)
that do not have comments returned to originator date. What I would like is
for documents that have been reviewed (ie the date comments returned field in
the second table has been entered) to be displayed in green and documents
that have not been reviewed (ie the date comments returned field in the
second table is blank) to be displayed in red.

Can this be done in the conditional formatting section in the report design.
If so, what expression is required?

Your help is much appreciated.

Thanks
Nic
 
Back
Top