Calculating in a form

[Darkwater]

Hi,

This is my first post to the forum and thanks so far for the answers I have gotten already just by searcing. I've got to a point where I don't even know what question to ask for this problem:

I have created a sub-form to a 'clients' form called 'Needs' showing a list of 13 specific needs of people that my team support. Each need has to be scored from 1 to 10 and be re-scored every three months (or sooner). I also have a total score field that will be used to summarise the distance travelled in a persons move towards independance that I would like to be able to put in to some form of chart to give the person a visualisation of how well they are doing and where necessary, where more work is needed through charts showing distance travelled on each individual need.

I have named each need in a table and set the data type to number with a field size of double. I have called the total scores field 'total.

How do I get the scores from the 13 needsfields in to the total field?

Thanks for reading, and for any assistance offered.

 

[mhartman]

Hello:

Please see the enclosed sample. Run the query. It has an example of how to total fields.
Regards
Mark

 

[Darkwater]

Thanks Mark. Much appreciated! I haven't gotten around to trying it out yet but will post when I get the chance.
Doug