Show Conditional Total in Group Footer (1 Viewer)

[Sazed]

Scenario:
on the Report the Expiry Cell color is:
Green if the Expiry Date is between Now()+35 and Now()+180
Pink if the Expiry Date is between Now() and Now()+35
Red if the Expiry Date is below <Now()
This function works fine as you see here on the picture below.
Requirement: I want to show the Total of Red, Pink and Green on the Group Footer area.
Appreciate your help to resolve this issue.

 

[Ranman256]

Set the box in the report,via Conditional formatting btn.
In the query, add field to count the days....
Daydiff("d",[datefield],now)

 

[Gasman]

Use DCount with the same criteria you used for the CF ?

 

[Pat Hartman]

I would use a subform that totals the report's RecordSource. Using functions requires hard coding values which is fine although inefficient if they are stable but if they are not stable, you will find yourself frequently making changes to the report as new values need to be "counted"