G
Guest
I have posted a couple of posts previously,but am still not getting the
result I need.
I want to produce a report of staff qualifications and to count how many
staff are qualified. However some staff have more than one qualification, but
I want to count them just once (I need to produce % of staff qualified)
It was suggested to use the unique values property in the underlying query,
but as the staff can be qualified in more than one subject, their records are
not unique. (I need to list the subject in this query as the subject is also
a criteria)
For example one member of staff's 2 records listed in the query would be
status=complete, award = management 4, employeeID=10 AND
status=complete, award = care 4, employeeID=10
I want to count employeeID=10 only once
What am I missing? How do I do this?
Part of the original post gave an example as follows.
What am I missing????
result I need.
I want to produce a report of staff qualifications and to count how many
staff are qualified. However some staff have more than one qualification, but
I want to count them just once (I need to produce % of staff qualified)
It was suggested to use the unique values property in the underlying query,
but as the staff can be qualified in more than one subject, their records are
not unique. (I need to list the subject in this query as the subject is also
a criteria)
For example one member of staff's 2 records listed in the query would be
status=complete, award = management 4, employeeID=10 AND
status=complete, award = care 4, employeeID=10
I want to count employeeID=10 only once
What am I missing? How do I do this?
Part of the original post gave an example as follows.
What am I missing????