Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Posts
    79

    Unanswered: Calculating fields

    Basically, what I need to do is add 3 fields together and have the total show in a 4th field called “Total Amount”.

    The fields are currency fields.

    I have no idea how to do this. In Excel I know this is very easy. But how do I do this in access?

    Any help is greatly appreciated.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    where?
    you can achieve this easily in a form, a query, or a report: the howto depends where you are.

    izy

  3. #3
    Join Date
    Sep 2002
    Posts
    79
    i want it done in a form.

  4. #4
    Join Date
    Mar 2003
    Location
    Southington, CT
    Posts
    8
    Originally posted by alex8111
    i want it done in a form.
    Set the Control Source property of the 4th text box to:

    Code:
    =([txtBoxOne]+[txtBoxTwo]+[txtBoxThree])
    Remember, "txtBoxOne"... referrs to the names of the text boxes on your form. You must set the Name property (on the "Other" tab) for each in order to reference to them properly.

    JDS

  5. #5
    Join Date
    Sep 2002
    Posts
    79
    Why in control source? I also would like for it to go into the table.

  6. #6
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Red face In a table

    Calculated fields should not be stored in a table.

    If they can ALWAYS be calculated from fields which are stored why bother storing them at all? - Breaks "The Rules" of relational database design.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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