By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 1,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Audit Report - Calculation needed

P: n/a
We have a simple database which stores employee audit results. Many
audits are done on each employee. I have a table with int_AuditNumber,
txt_Name, and txt_Score. The txt_Score field shows the result of the
audit and can only be "Correct", or "Error".

I have a corresponding report that summarizes how each empoyee is
doing. It shows employee's name, and calculates (via the count
function) the # of audits with "No Error" for that person, and then
Number of audits with "Error" for that person.

What I need to do is to calculate each employee's error rate. For
example if we've done 20 audits on Joe Smith, and he has only 1 error,
then his error rate is 5%.

In plain language my calulation would say "Count Number of records for
this person which are 'Correct', and divde by the total count for that
person.

Can someone please steer me in the right direction. I'm new to Access
and often confused about whether I should be calculating something in a
query, or if I can do it in a report.

Thanks,
Jason

Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I figured it out.... thanks.
kiplinghfx22 wrote:
We have a simple database which stores employee audit results. Many
audits are done on each employee. I have a table with int_AuditNumber,
txt_Name, and txt_Score. The txt_Score field shows the result of the
audit and can only be "Correct", or "Error".

I have a corresponding report that summarizes how each empoyee is
doing. It shows employee's name, and calculates (via the count
function) the # of audits with "No Error" for that person, and then
Number of audits with "Error" for that person.

What I need to do is to calculate each employee's error rate. For
example if we've done 20 audits on Joe Smith, and he has only 1 error,
then his error rate is 5%.

In plain language my calulation would say "Count Number of records for
this person which are 'Correct', and divde by the total count for that
person.

Can someone please steer me in the right direction. I'm new to Access
and often confused about whether I should be calculating something in a
query, or if I can do it in a report.

Thanks,
Jason
Oct 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.