Sort and count in header

[johngmurphy1@msn.com]

Hi



I have a report that list actions to be completed by a certain date (timeline). Each of these actions has a RAG status (red, amber green and closed). I have managed to show the count of the actions that need to be completed by the date (in the timeline header). I want to show the RAG status next to that count - x are red, y are amber etc - can you help?

[ranman256]

make a subform (subReport) this has the counts.
in the report ON PRINT event, you can set colors:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next

Select Case AbsRate.Value

   Case "Red"
      lbl50.BackColor = vbRed

   Case "Blue"
      lbl50.BackColor = vbBlue
    
    Case Else
      lbl50.backcolor = vbWhite
End Select
End Sub