Averaging Scores

[Guest]

I have created a form to evaluate employees. They receive and overall "pass"
or "fail". How can I represent the overall result of multiple evaluations on
a report? I would like to show %pass and %fail or something of the like.

 

[Guest]

Not knowing your data structure, you might do something like:

SELECT EmpID, Emp_Name, _
Format(SUM(iif([Eval] = "Pass", 1, 0)) / SUM(1), "percent") as
PassPct
FROM yourTable
GroupBy EmpID, Emp_Name

HTH
Dale

 

[Guest]

I have a field called "Overall Evaluation" that results in a Pass or Fail.
This comes from a table named "Repair". Does this help?
--
Drock-13

Not knowing your data structure, you might do something like:

SELECT EmpID, Emp_Name, _
Format(SUM(iif([Eval] = "Pass", 1, 0)) / SUM(1), "percent") as
PassPct
FROM yourTable
GroupBy EmpID, Emp_Name

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.

I have created a form to evaluate employees. They receive and overall "pass"
or "fail". How can I represent the overall result of multiple evaluations on
a report? I would like to show %pass and %fail or something of the like.

 

[Guest]

I am not clairvoyant!

Are there any other fields in this table that are important to your query
(EmpID, ...)? Or maybe this table (Repair) needs to link to some other table.

What do you want the output of the query to look like? or do you just want
to display this value on a form, for a single user?

Dale


--
Email address is not valid.
Please reply to newsgroup only.

I have a field called "Overall Evaluation" that results in a Pass or Fail.
This comes from a table named "Repair". Does this help?
--
Drock-13

Not knowing your data structure, you might do something like:

SELECT EmpID, Emp_Name, _
Format(SUM(iif([Eval] = "Pass", 1, 0)) / SUM(1), "percent") as
PassPct
FROM yourTable
GroupBy EmpID, Emp_Name

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.

I have created a form to evaluate employees. They receive and overall "pass"
or "fail". How can I represent the overall result of multiple evaluations on
a report? I would like to show %pass and %fail or something of the like.

 

[Guest]

The table is called repair. I include the fields Review of, Reviewed By,
Claim number, Review date, variance over, variance under, actual value,
percent variance and Overall Evaluation from the repair table in the query.
The overall evaluation results value is either pass or fail. I have the
report summarizing the variance over, variance under and percent variance. I
want to summarize the Overall Evaluation by showing the percent passed, per
person in the Review Of column.

Thanks
--
Drock-13

I am not clairvoyant!

Are there any other fields in this table that are important to your query
(EmpID, ...)? Or maybe this table (Repair) needs to link to some other table.

What do you want the output of the query to look like? or do you just want
to display this value on a form, for a single user?

Dale


--
Email address is not valid.
Please reply to newsgroup only.

I have a field called "Overall Evaluation" that results in a Pass or Fail.
This comes from a table named "Repair". Does this help?
--
Drock-13

Not knowing your data structure, you might do something like:

SELECT EmpID, Emp_Name, _
Format(SUM(iif([Eval] = "Pass", 1, 0)) / SUM(1), "percent") as
PassPct
FROM yourTable
GroupBy EmpID, Emp_Name

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.


:

I have created a form to evaluate employees. They receive and overall "pass"
or "fail". How can I represent the overall result of multiple evaluations on
a report? I would like to show %pass and %fail or something of the like.