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.
*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: