In my Access 2010 report, I am attempting to perform conditional formatting of one field based on the difference between two fields.
In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.
Any recommendations how I can conditionally format to do this? I appreciate your help ahead of time.
In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.
Any recommendations how I can conditionally format to do this? I appreciate your help ahead of time.
Conditional Formatting Two Fields in Report
0 commentaires:
Enregistrer un commentaire