Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Location
    Alabama
    Posts
    37

    Unanswered: Listbox Question

    Access2000

    Greetings:
    I have a list box on a form that gets its data from a query; one of the columns contains a number value. I have a textbox, also on the form, which needs to display the sum of the numbers in the list box column. Is that possible?

    Thanks

  2. #2
    Join Date
    Dec 2006
    Posts
    53
    That seems like it could be done in VB. Can you pose an example? Maybe take a screenshot of the form and reference the listbox and textbox fieldnames.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Perhaps run a summation query on that query ... Or you could iterate thru the listbox summing as you go ... Or you could do the summation on the same table(s) that the listbox query is based on ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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