« How has your experience with Alpine Access been?
How to build a project in MS.Access in the title of (corporate strategies and information management system)? »

How do I rank suppliers by their unit cost for each comodity in MS ACCESS?

My table contains three unit prices for three different suppliers. I would like to rank the cheapest supplier, the second best and the most expensive supplier for each commodity in MS Access 2000. All suppliers provide the same commodity but each at a different unit price. The result should give the cheapest

Since I don’t know your Table structure, I’ll assume You did this RIGHT and have a table with Supplier, Comodity, Unit Cost
Build one query that Groups by Comodity and shows the Lowest Cost (Set your SUMMARY row to MIN).

Build a 2nd Query that links the 1st Query to the Table by Unit Cost. This will show You for each Comodity the supplier wth the Lowest Cost.

This entry was posted on Wednesday, February 10th, 2010 at 12:26 pm and is filed under ms access. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I rank suppliers by their unit cost for each comodity in MS ACCESS?”

  1. Capt Crasher Says:
    February 10th, 2010 at 5:35 pm

    Since I don’t know your Table structure, I’ll assume You did this RIGHT and have a table with Supplier, Comodity, Unit Cost
    Build one query that Groups by Comodity and shows the Lowest Cost (Set your SUMMARY row to MIN).

    Build a 2nd Query that links the 1st Query to the Table by Unit Cost. This will show You for each Comodity the supplier wth the Lowest Cost.
    References :

Leave a Reply