Counting records from different fields

[Guest]

in the report footer i have this expression:
=IIf([Health Region]="CNAHS",Sum(Abs([Bed_Type]="Acute")),"0")
What i have are three regions and what i would like to do is count the
number of field there are within each region for a particular bed type.
The above function works fine for the health region CNAHS but for the other
two regions it returns the false argument and displays a zero. There are at
least 4 records that are associated with the other regions.

What am i doing wrong????

 

[Allen Browne]

Brett, try something like this:

=Sum(IIf(([Health Region]="CNAHS") AND ([Bed_Type]="Acute"), 1, 0))

 

[Guest]

Thankyou Allen. Works like a charm!

Brett, try something like this:

=Sum(IIf(([Health Region]="CNAHS") AND ([Bed_Type]="Acute"), 1, 0))

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in the report footer i have this expression:
=IIf([Health Region]="CNAHS",Sum(Abs([Bed_Type]="Acute")),"0")
What i have are three regions and what i would like to do is count the
number of field there are within each region for a particular bed type.
The above function works fine for the health region CNAHS but for the
other
two regions it returns the false argument and displays a zero. There are
at
least 4 records that are associated with the other regions.

What am i doing wrong????