J
Jolyn
I have a report, grouped by medical area, and sorted by
staff, as follows:
medical area 1
staffname 1 intake
staffname 1 xray
staffname 2 xray
staffname 2 medication
staffname 3 check out
medical area 2...
I need to count the number of people that have worked in
each medical area, and then use that number as the
numerator of a percent (of total staff).
Count([staff name]) doesn't work. In the example above,
it gives me 5 for medical area 1, when there should be 3.
I can use the RunningSum "over group" property in a text
box [runningsumofnames] in the Staffname footer of the
report, but I don't seem to be able to use the result in a
calculation. When I try, it gives me a parameter query
message asking for the value of [runningsumofnames].
I am assuming from all of this that Access doesn't see
runningsum as a numeric field. (I did set the format as
General Number.) Is there any way around this? Or any
other ideas?
FYI, I tried the suggestions in the newsgroup from the
post on 11/28/03 "counting unique values". At first this
seemed like my answer, but since I'm trying to calculate
this within a grouping by medical area, I can't see how to
make it work.
Any help will be appreciated. Thanks.
Jolyn
staff, as follows:
medical area 1
staffname 1 intake
staffname 1 xray
staffname 2 xray
staffname 2 medication
staffname 3 check out
medical area 2...
I need to count the number of people that have worked in
each medical area, and then use that number as the
numerator of a percent (of total staff).
Count([staff name]) doesn't work. In the example above,
it gives me 5 for medical area 1, when there should be 3.
I can use the RunningSum "over group" property in a text
box [runningsumofnames] in the Staffname footer of the
report, but I don't seem to be able to use the result in a
calculation. When I try, it gives me a parameter query
message asking for the value of [runningsumofnames].
I am assuming from all of this that Access doesn't see
runningsum as a numeric field. (I did set the format as
General Number.) Is there any way around this? Or any
other ideas?
FYI, I tried the suggestions in the newsgroup from the
post on 11/28/03 "counting unique values". At first this
seemed like my answer, but since I'm trying to calculate
this within a grouping by medical area, I can't see how to
make it work.
Any help will be appreciated. Thanks.
Jolyn