Results 1 to 3 of 3

Thread: Sum

  1. #1
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58

    Unhappy Unanswered: Sum

    This is a repeat question but no one answered me. Sorry. How do I sum a column in a listbox? In the listbox I want to sum column 6. I know this is wrong but I have the following code:

    Code:
    me.txtbox = sum(me.lstbox.column(6))
    Thanks for your help in advance...

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi

    I suppose the reason for no reply was not many people will want to sum a list box... Its an unusual system..

    What are you attemptng to do for what purpose and may be an answer will be forthcoming that just could be helpful to you


    regards
    gareth

  3. #3
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58
    The main form is a transaction form with a listbox with items that are sold for that transaction. I have button under the list box that when I click it opens up another form and you can add details about that line item. When I save the record its populates the list box with the name, price, tax, etc... I want to sum the total price so I can populate the main tranaction form with the total unit price, sales tax, and total price.

Posting Permissions

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