Just Want to Count Records

[pcca]

I have several questions about my clients that are yes/no answers e.g. Was the client referred by a hospital? Was the client referred by a physician? etc.

I want to be able to count the number of records for each yes/no question. i.e. 5 clients were referred from a hospital, 3 clients were referred by a physician, etc.

I'm sure its simple but it just escapes me!

 

[raskew]

Hi -

abs(Sum([Hospital Field]))

...should return a count of Yes responses since a Yes/True response returns -1 while a No/False response returns 0. Abs() will return a positive response, e.g. if the Sum() function returns -5 (5 yes/true responses), Abs() will return 5.

HTH - Bob