Summing Fields

twitchie

Registered User.
Local time
Today, 02:16
Joined
Jan 16, 2003
Messages
41
I have a form on which people are scored. There is a field [TotalScore] that sums the scores as they're selected (1 thru 5 in a combo box) on the form. This portion works fine. However, getting that sum to the report is where I'm having trouble. Since the control for the form field [TotalScore] is just =UnformCode+Ambition, I don't know what to use as the control for the sum on the report. If I want to save the [TotalScore] from the form to the table (which I do) and use that as the control source, the math doesn't work on the report. What am I doing wrong here? TIA!

*EDIT* As usual, I post and then figure it out. Wow, I was making that soooo much more difficult that it had to be! Thanx for looking and being willing to help anyhow. Still appreciate your time.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom