Distinguishing data in a report

keke10

New member
Local time
Today, 02:25
Joined
Jul 29, 2005
Messages
8
I have developed a report containing hours worked for employees and consultants. I would like to highlight all hours about 36 for employees and those above 44 for consultants. I've tried conditional formatting, however this doesn't allow me to distinguish between the types of workers. Is there another way to achieve the above?
 
Thanks for the assistance, however this code is not working. In the project table linked to this report there is a field containing a check box that distinguishes an employee from a consultant. There isn't a seperate worker type field, which distinguishes the two. Only this check box. If the check box is checked, the individual is a consultant. If it isn't checked, they automatically fall into the employee category. I'm thinking this check box has something to do with the difficulties I am experiencing while trying to build this code. Is there a way to factor in whether the "Consultant Check Box" is true or null to distinguish the two before factoring in the >36 and >44 parameters?
 

Users who are viewing this thread

Back
Top Bottom