actually I did go into conditional formating. I can get the entire column to highlight if I key in something like ([Obstetrics Same Day Stay] >0) Out of 31 days in October our OB department only had 1 Same day stay and that was 10/3. What I'd like to happen to only have that day highlighted. I read where I needed to change the name to something other than the established control or field but that didn't work either. When I pull up the property sheet the Name is Expr1 and the Source is Expr1. It doesn't list the entire equation. That being the case, can Access still see if the Same Day value is greater than 0? Actually it's not jut the OB department that I need to set up. It's also Medical, Surgical, ICU, etc. Any suggestions would be appreciated. The control in the Query is the one I listed in the original post. Also in the conditional formatting I used the first condition to define the control, then the second condition was to select the control from the Daily Census Report Table and then the third condition was ([OB SD] >0). Everything I've tried has been either the entire column has been highlighted or none of its been highlighted.