Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    20

    Exclamation Unanswered: Report Sum Problem

    I have a report and all I want is for a field in the report to display a total sum of the different values of one text box in all records displayed.

    For example, someone told me to try =sum([txtboxname]) and enter that into a new text box.

    This doesnt work. All that happends is when i run the report it prompts me to enter search criteria for txtboxname...for some reason it is recognizing the sum command is some kind of a search field.

    Can someone tell me where to put this and how to do it so it will total the field i need to totaled.

    Thanks,
    Ryan

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can't sum a control (textbox), but you can sum a field in the data of the report's underlying table/query, so:

    =Sum(DataFieldName)

    would work. Watch out if a control has the same name, as that can cause problems.
    Last edited by pbaldy; 06-12-06 at 02:35.
    Paul

Posting Permissions

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