B
Brett
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????
=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????