J
Jim Normile
I am extracting client records into a query, which is then
used to produce a report. A client will be described by
gender from a lookup of genders; by location from a lookup
of four locations; and by credit rating from a lookup of
four different credit ratings;
In the report footer I can create a calculated field to
count males as follows "=Count(iif([gender]="Male",0)) and
it works fine.....likewise female
I can use the same device to count different locations and
credit ratings, but I'm stumped when I try to combine...
What I want to do is count IF "Gender" is male
AND "Location" is North America AND "Credit Rating" is
Excellent.......
I think I must write a count based on an IIF/AND. The
problems are
1) is Access capable of supporting this
function combination??....(I expect the answer is
yes)....and (2) I don't know how to write the combo!!...so
a little advice would be gratefully received
Thanks in anticipation
Jim
used to produce a report. A client will be described by
gender from a lookup of genders; by location from a lookup
of four locations; and by credit rating from a lookup of
four different credit ratings;
In the report footer I can create a calculated field to
count males as follows "=Count(iif([gender]="Male",0)) and
it works fine.....likewise female
I can use the same device to count different locations and
credit ratings, but I'm stumped when I try to combine...
What I want to do is count IF "Gender" is male
AND "Location" is North America AND "Credit Rating" is
Excellent.......
I think I must write a count based on an IIF/AND. The
problems are
1) is Access capable of supporting thisfunction combination??....(I expect the answer is
yes)....and (2) I don't know how to write the combo!!...so
a little advice would be gratefully received
Thanks in anticipation
Jim