My report is attempting to track how many loads a day are being delivered to the customer by each driver. We have two customers and want to make sure drivers are not just delivering to only one customers. User wants only to see the total deliverys per driver in one column, but color coded. So customer1 is "Red", customer2 is "Blue" delivered to both is "Green".
Right now I am using a count function on the customername column. I get the correct number of loads per driver for the day. I am just unsure how to change the font color based on the name when both customer names are present. IIF statements work for either or, but not both. I tried a switch() but still could not get it to work.