Results 1 to 4 of 4
  1. #1
    westfallbp is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2021
    Posts
    26

    Calculations on a form envolving 2 list boxes for 2 queries on an unbound form


    How would you and is it possible to make a calculation on 2 different list boxes. I have an unbound form, I have two listboxes.
    [list1] and
    [list2] Which both listboxes are based on there own querry List box 1 is query 1 and list box 2 is query 2. Both list boxes produce a sum total which is displayed on the form. However, I would like to take the value of List1 and subtract list2. Tota:
    [List1]-
    [List2] Is this possible and how?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,574
    Yes, just use simple math.
    Not sure why you are using a listboxes when there is only one entry for each?
    Why not just use textboxes?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    westfallbp is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2021
    Posts
    26
    The listboxes are a sum of a bunch of records based on a field which is a number formated as a currency. Yea, its easy to take Tota: [Text1]-[Text2] which would producte a result. You cant say that List1 is equal to Text1..Doesn't work like that. Sorry, I dont' think you may understand but thanks for trying.

  4. #4
    westfallbp is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2021
    Posts
    26
    Resolved: Had to create a query based on the other 2 queries and then do the calculations because of the aggreate query.

    Thanks for getting me to think about it.

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

Similar Threads

  1. Replies: 9
    Last Post: 04-16-2024, 05:08 AM
  2. Replies: 5
    Last Post: 01-07-2019, 01:51 AM
  3. Replies: 8
    Last Post: 12-13-2017, 10:38 AM
  4. Replies: 30
    Last Post: 09-30-2015, 10:58 AM
  5. Replies: 9
    Last Post: 11-06-2014, 01:15 PM

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