Results 1 to 4 of 4
  1. 04-29-2014, 09:31 PM #1
    rgrstvr
    rgrstvr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    25

    2 suppliers with rows of products, how to get result shown below?

    SUPPLIER AA
    1 aa jasmine $1
    22 aa strawberry $25
    35 aa chocolate $13
    42 aa hamburger $24

    SUPPLIER BB
    1 bb jasmine $12
    26 bb pickles $21
    35 bb chocolate $17
    72 bb hot dogs $34

    RESULTING INFORMATION
    1 aa jasmine $1
    22 aa strawberry $25
    26 bb pickles $21
    35 aa chocolate $13
    42 aa hamburger $24
    72 bb hot dogs $34
    Reply With Quote Reply With Quote
  2. 04-30-2014, 01:03 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    What are the rules for selecting records? The lowest price?
    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.
    Reply With Quote Reply With Quote
  3. 04-30-2014, 09:07 AM #3
    rgrstvr
    rgrstvr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    25
    yes - I would be dealing with a dozen suppliers and 5,000 products and need a quick and easy way to determine can supply the lowest price product.
    Reply With Quote Reply With Quote
  4. 04-30-2014, 11:19 AM #4
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Maybe this will help http://allenbrowne.com/subquery-01.html#TopN
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Eliminating duplicate rows in a query result based on one column
    By tracyd2475 in forum Access
    Replies: 4
    Last Post: 04-22-2014, 08:23 AM
  2. Query where each result consists of multiple data points from different rows
    By JAM7007 in forum Access
    Replies: 2
    Last Post: 06-24-2013, 12:37 PM
  3. Query showing count of the number of suppliers in each state?
    By jkklingelhofer in forum Queries
    Replies: 1
    Last Post: 04-14-2013, 06:54 PM
  4. How to keep track of products purchased and products sold with on products table?
    By pendlet in forum Database Design
    Replies: 8
    Last Post: 04-24-2012, 01:05 PM
  5. How to use DUAL table in MSaccess to add rows to a query result
    By baba in forum Access
    Replies: 1
    Last Post: 12-03-2011, 01:26 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums