Results 1 to 2 of 2
  1. #1
    Kab is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    1

    Group by one column

    I've created a report that groups by the item. In this grouping there are 3 items each with their own related quantity that takes to build the item.
    For example say I want to make apple juice, it takes one teaspoon of sugar, one cup of water and 2 cups of lime juice to build one cup of apple juice.
    Now, i want the user to enter how many apple juice they want to build, how can I get the information for each item in the grouping and calculate how much each item takes? Can this be done without a report?

  2. #2
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,288
    You *should* be able to create a form to select the Item and see the components to make the item. BUT I don't know your dB design.

    Maybe you would post your dB?
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 2
    Last Post: 11-19-2018, 09:15 PM
  2. Replies: 11
    Last Post: 08-16-2018, 10:26 AM
  3. Two-column report with group by number
    By bamerand in forum Reports
    Replies: 1
    Last Post: 10-30-2014, 09:07 AM
  4. Replies: 9
    Last Post: 05-29-2012, 11:03 AM
  5. Replies: 2
    Last Post: 12-05-2011, 04:53 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 - Senior Forums