Results 1 to 5 of 5
  1. #1
    yagerlegi is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    29

    Help with Text calculation

    Hello,



    I have a form that have 2 list boxes on it. The 1st list box is controlled by a combo box and displays item when the combo box is selected, the 2nd box display item based on the item selected in the 1st list box. How can I get a calculation of the 2nd list box to display? I need help displaying a total in a text box or at the bottom of the second list box.

    Thx,
    Last edited by yagerlegi; 12-04-2014 at 02:30 PM.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    What do you mean by 'calculation of the 2nd list box'? What do you want to calculate? Can't really do an aggregate calc of values in listbox. Use a subform.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    I agree with June - what do you want to calculate?
    Suggest it would be helpful and less confusing if you told us in plain English what you are trying to accomplish.

  4. #4
    yagerlegi is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    29
    Sorry, English is my second language.
    I want to calculate the number that is listed in the second list.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    That information doesn't really tell us much and doesn't alter the advice given.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 11-13-2014, 12:08 PM
  2. Replies: 29
    Last Post: 06-05-2014, 09:34 AM
  3. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM
  4. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  5. Replies: 1
    Last Post: 05-24-2012, 04:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums