Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation in textboxes (2000)

    Hi Guys,
    i have a frmDebitNote based on tblDebitNote, and I want to calculate the sum of the 3 fields named..
    Amount
    txtAmount2
    txtAmount3
    So what will happen after the numbers have been inputed, it will sum it up and store it in the field "total".
    Thankyou in advance
    Attached Files Attached Files

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

    Re: Calculation in textboxes (2000)

    In general you should not store Total in the table, since it is derived information. You can calculate the sum in a query, by creating a calculated column:

    Total: [Amount]+[Amount2]+[Amount3]

    You can also calculate it on the form, by setting the Control Source of theTotal text box to

    =[Amount]+[Amount2]+[Amount3]

    If you do need to store the total in the table, see <post#=330877>post 330877</post#>. The method described there can be adapted to your needs.

  3. #3
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation in textboxes (2000)

    ok, thanks Hans. Got it working now, much appreciated [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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