(formating didn't work...see two rows (ID1 and ID2) and three columns (5/24, 5/25, 5/26)
Only I want the 0%, 25%, 75%, or 100% to be different colors (ie. red, orange, yellow, and green) for the different levels of completion.
I have no problem getting a cross tab query to just put the data in this format. And I know how to put it into a report so I can add color, however that only works if the dates always stay the same. The dates will always be changing, and may be an input for the query, so I don't know how to make it work (why won't it just work?!?!?). Does anyone have a suggestion on how to make this work? Please help, I'm at a loss.
Let me know if I can better describe what I'm looking for and thanks for the help!
In the report detail on_format event do something like this
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
select case Me.test
Me!test.ForeColor = vbRed
Me!test.ForeColor = vbBlue
case = 0.5 Then
Me!test.ForeColor = vbBlack
Case = 0.75 Then
Me!test.ForeColor = vbYellow
Me!test.ForeColor = vbGreen
On some later versions of Access there is a format switch for this function - see help for this idea.
You can use system colors to get a numeric value for orange as ther is no intrinsic constant for orange.