Count/sum on background colour?

[jessboo]

I have set a field to change background colour according to a date parameter. Is it possible to sum or count the number of fields based background colour? e.g. count how many fields have turned blue?

 

[MSAccessRookie]

I have set a field to change background colour according to a date parameter. Is it possible to sum or count the number of fields based background colour? e.g. count how many fields have turned blue?

I don't know about polling a form for status like that, but can't you modify the Query behind the Form to count the number fo fields that qualify to be turned to the new background color?

-- Rookie

 

[jessboo]

I've tried but I'm quite new to crystal and I can't quite get it. I've grouped by project number, and I want to count how many dates within each group fall within a date parameter. I've highlighted them so I can see them at a glance, using:

if {ENQORDER.dateinit}={?Date Sent} then crFuchsia else crNoColor

but if I do a similar formula using count, it counts dates within the parameter for the whole report rather than the group.