Results 1 to 3 of 3
  1. #1
    Lortiz70 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Location
    Texas
    Posts
    3

    Rank item by price and vendor

    I have a table called ItemList and a table called ItemVendor. Item list is a listing of all parts. Items cannot be duplicated. ItemVendor is all the possible vendors for the items in ItemList. Based on lowest price to highest price, I want to automatically set the vendor ranking.

    Item Vendor Price Rank
    MM-01234 XYZ 4.00 2
    MM-01234 ABC 3.00 1

    Without allowing duplication's of vendor rank. You cannot have Rank 1 for the same item and vendor.

    Any Help would be appreciated. Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Here are some thoughts:

    http://allenbrowne.com/ranking.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Lortiz70 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Location
    Texas
    Posts
    3
    Thanks so much... I will take a look.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-16-2016, 09:50 PM
  2. one Price for first item, another price after that...
    By santinimatias in forum Database Design
    Replies: 3
    Last Post: 02-11-2015, 03:11 PM
  3. Replies: 9
    Last Post: 03-13-2014, 07:42 AM
  4. Item without price, or duplicate price
    By Auto in forum Reports
    Replies: 5
    Last Post: 07-29-2013, 09:46 PM
  5. Replies: 5
    Last Post: 07-29-2011, 12:55 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