Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003

    Unanswered: Average and SD of fields on a form

    Hi all,
    I have a form where I record test results.
    Each test is performed 10 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


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Which is precisely why you should never have field arrangements such as test1 test2 test3 etc.

    Each test should be in it's own record, then you can just apply functions to the columns.

    Your only way to do it with that structure is manually -- (test1 + test2 + test3) / 3 for example.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2003
    Well i guess everyones app is different
    Does anyone else have experience of doing this?
    Happy to write some code to do this..

  4. #4
    Join Date
    Jun 2007
    Maitland NSW,Australia
    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts