I tried this, and it didn't seem to work. I created a week field in my query
week: DatePart("ww",[dateField])
Then followed your instructions.
I need to change the background color for all of the fields but base it on the [dateField]
field value is equal 1 (White)
field value is equal 2...