Coffee worked!! -> ABS(SUM([SoilAcidity]=True))



Cheers,



Andrew



-----Original Message-----

From: Haslett, Andrew [mailto:andrew.haslett@i...]

Sent: Thursday, 21 February 2002 4:37 PM

To: Access

Subject: [access] Report Groupings





Hi gang.



Must be lack of sleep but the brain is just not producing at the mo!!



I have a number of land properties, grouped by state, and I want to COUNT

the number of times a certain field is equal to TRUE for each particular

state.  So in State A there maybe 100 properties, of which 35 have the 'Soil

Acidity' field value of TRUE.



In the State Footer I have an expression of COUNT([SoilAcidity]=True), but

all it seems to do is count the total number of properties for that state.

IE - it doesn't use the expression.



Anyone have any ideas, while I go and get a quadruple coffee hit??



Cheers,



Andrew