Results 1 to 2 of 2
  1. #1
    choppper is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2009

    ms access - lookup / find product name for lowest price in category


    I've got a table with the following information:

    Vendor ProductCategory Price
    farm1 apples $1
    farm2 apples $2
    store1 bandaids $10
    store2 bandaids $7

    I want to run a query to find the minimum price for each category, and also show the vendor. So the result should be:

    Vendor ProductCategory Price
    farm1 apples $1
    store2 bandaids $7

    Of course, if I group by category and the minimum of price, it will find the cheapest in category, but I'll lose visibility to the vendor. I've tried setting it up as two tables - a product table and a product category table, but it hasn't worked so far.

    Thanks for the help!

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    If you bring in the table again and create links on both the cost and the item and bring down the vendor it should dispplay the correct vendor.


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

Similar Threads

  1. return last updated date for each product
    By jonnyuk3 in forum Queries
    Replies: 0
    Last Post: 06-17-2009, 04:38 AM
  2. Multiple Price Columns
    By kmwhitt in forum Access
    Replies: 0
    Last Post: 04-04-2009, 09:48 PM
  3. Microsoft Access Lookup tables
    By bitert01 in forum Forms
    Replies: 1
    Last Post: 02-20-2009, 02:55 PM
  4. Product in a Summary Query
    By Fletch in forum Queries
    Replies: 0
    Last Post: 12-11-2008, 03:14 PM
  5. Replies: 0
    Last Post: 08-19-2008, 11:12 AM

Tags for this Thread

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