Get Sum Value from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, I have a form that has a total of 12 fields (scores), each will have a numerical value inputted into it by the user. On that same form, I have a box that displays the TOTAL of those 12 fields (the total score).

My problem is, I want to run a report that will sort the TOTAL scores from each record from highest to lowest. However, when I try to create my report, it wants my TABLE name (where it is pulling the data from). The TOTAL SCORE field is not in my table, it is only calculated within my form. And besides, after all the reading here, noone suggest storing a calculated field in a table anyway

So how do I pull the TOTAL SCORES field from my form and output it to a report that is sorted from highest to lowest score

Thanks for ANY help

Tammy
 
Maybe you attach the report to a query that pulls the total plus * all from the
table
(e-mail address removed)
 
Back
Top