Hello,

I'm having a problem dividing in my form.

I have 3 fields...the first field adds up check boxes and the second field adds up boxes with no checks.

I want the third field to divide the first field result by the second field result to come up with a percentage, but the division doesn't want to work.

In my table, I have the third field as data type "Number", and in the field properties the format is "Percent". I also changed the format of the field in the form to percent. Here is my formula in the "On Click" event procedure:

Private Sub Score1_Click()
Me![Score1] = Sum(Me![PointsEarned1] / Me![PossiblePoints1])
End Sub

I've also tried with without the "Sum"

Private Sub Score1_Click()
Me![Score1] = Me![PointsEarned1] / Me![PossiblePoints1]
End Sub

I've also tried entering the whole formula for my Points Earned field & dividing that by the whole formula for my Possible Points field.

None of them want to work... it just says "1" in the field box. Is there an easier way of doing this?

Thanks!

Please don't post the same question in multiple places.

Sorry...it was an accident. http://www.access-programmers.co.uk/ubb/smile.gif