percentages in an update query

[Gianna]

I am trying to calculate 2 types of percentages:

A:
I need my query to tabulate a percentage for correct
answers in a section of a test...

Example: I have 5 electrical questions and a student
gets 4 right, I should tabulate 80%

[electricalanswers]/5

My update query comes up with 100%, why???

B:
I need an overall percentage
I have a field named Correctanswers
[electrical]+[machines]=correctanswers (total of 10),
now I need a percentage
[correctanswers]/10, so if a student got 5 out of 10 right
that should be 50%, but my query comes up with either 100%
or 0.00%, why???

 

[Dale Fye]

Gianna,

Cannot help you unless you post your querys as they currently exist.
Would also help to know just a little more about the table structure.

--
HTH

Dale Fye


I am trying to calculate 2 types of percentages:

A:
I need my query to tabulate a percentage for correct
answers in a section of a test...

Example: I have 5 electrical questions and a student
gets 4 right, I should tabulate 80%

[electricalanswers]/5

My update query comes up with 100%, why???

B:
I need an overall percentage
I have a field named Correctanswers
[electrical]+[machines]=correctanswers (total of 10),
now I need a percentage
[correctanswers]/10, so if a student got 5 out of 10 right
that should be 50%, but my query comes up with either 100%
or 0.00%, why???