I have a form where I record test results.
Each test is performed 10 times...so the fields are named 'test1', test2' etc.
test1 and test2 etc are also fields on the table behind the form (thats were the data goes).
So I need to calculate the average of test1, test2...testn and also the standard deviation. I tried this using a query but I can only do an average on columns (multiple record sets) and not the fields within 1 recordset.
Does anyone know how to do this?
Thanks in advance
The attached is a sample database using unbound textboxes to give you an average of three fields. You will need to continue the numbering of each textbox to 10. There are three calculated fields below the input textboxes for the display of the code calculations.
SD can not be done easily across fields, it will require a lot of coding.