Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009

    Unanswered: How to Sum a value in a text box

    Hi All,

    i want to know how to sum a value in a text box which appears in a group header in an access 2000 report.

    I have tried using:
    =Sum([txtAmount]) - 'txtAmount' is the name of the textbox that holds the value

    but it does not work. When i run the report it treats it as a parameter value and you have to enter a value before it will display the report, but the value is incorrect anyway.

    Any help would be most appreciated, the sooner the better.


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Is txtAmount by any chance a calculated value? You can't use Aggregate Functions against calculated fields, you have to use them against the expressions used to calculate them. If

    C = A + B

    you can't use


    you have to use

    Sum(A + B)
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2009
    txtAmount is not a calculated field. It is manually entered by the user, and is dependant on the price that was agreed with the customer.

  4. #4
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Manually entered where?

  5. #5
    Join Date
    Nov 2007
    Adelaide, South Australia
    Is txtAmount a field in a table??
    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

Posting Permissions

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