Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated total (Access 2000 Service Pack 3)

    I have created a form which my staff enter test scores into. The form was created off of a table first with the same fields. However, on the form I made the grand total column automatically add up the totals from 1 person's test which has part 1, 2, and 3 for each patient. This works very well because I know the computer does not add incorrectly.

    The test is given before treatment and after treatment. As mentioned above the Pre and Post Test has 3 parts which we want the grand total of the Pretest (part1, 2, & 3) and Post Test (part 1, 2, 3). Because they only enter the totals for each part and not the grandtotal, the Outcome studies table does not post the grandtotal for Pre and Post.

    I know it has to do with the grandtotal field being calculated in the entry form. How do I make the table read the automatically entered total from the grandtotal on entry form?

    Now, I know I have totally confused everyone.

    I pull my queryies from the table and want to graph the progress between entry test score total and exit test score total.

    Thank you for any help. <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated total (Access 2000 Service Pack 3)

    The standard advice is not to store calculated data in a table, since (a) it is redundant and ([img]/forums/images/smilies/cool.gif[/img] it can easily be recalculated each time you need it. Instead, create a query based on the table, and add calculated columns to compute the totals. That way, even if a score has to be corrected afterwards, the totals will still be correct, because they will be recalculated each time.

    There are some exceptions to the above. If recalculating the values each time you need them is very time-consuming, and if the underlying values change rarely after they have been entered, you can add fields for these values to the table. You can fill those fields in the Before Update event of the form. (You must NEVER allow users to modify or enter values in the table directly). The code would look like this, of course with the appropriate names substituted:

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me.StoredPreTotal = Me.CalculatedPreTotal
    Me.StoredPostTotal = Me.CalculatedPostTotal
    End Sub

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculated total (Access 2000 Service Pack 3)

    <hr>I know the computer does not add incorrectly.<hr>
    This is not necessarily true. It depends on the datatypes you're dealing with. Floating point error occur in simple addition and subtraction when using Single or Double datatypes.
    Charlotte

Posting Permissions

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