Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Sum of combo box access reports

    Hello,

    I'm designing an access report, and in one field or text box I need to be able to display the sum of a combo box.

    For instance:

    Field text17 I want to display the sum or total of all values of the combo box that equal the word "Won"

    Field text18 I want to display the sum or total of all values in the combo box that equal the word "Lost"

    The combo box is named won/lost

    Does anyone know what coding I could use in the access report to make this happen? Thanks in advance.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can't sum a control, but you can sum a field in the report or group footer:

    =Sum(FieldName)
    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
  •