Query to change colour of text

N

Neal

Hello I have a report that works out employees shifts which is based on a
query. I am trying to make the report display the employees name in Red if
he is on holiday for a shift. All my attempts seem not to work or if I add
the holiday table to the query and use conditional formating it shows the
employees name twice on the report one in red and one in black. can anyone
help or suggest anything
Thanks for reading.
 
Top