PC Review

Thread Tools Rate Thread

need to rank in a query

Posts: n/a
      2nd Sep 2010
Hi all here is my problem. I need to find the last vendor for a part
that was bought. I have a table with all of the receipts. The problem
is if i group by the part and vendor and look for the max delivery
date, i get the last time the part was bought for each vendor it was
bought from. i want the last vendor period. example

part ABC was bought from vendor 1 on 8/23, vendor 2 on 8/12 and vendor
3 on 7/25, when i run the query i get this

Part Vendor MaxofDate
ABC 1 8/23
ABC 2 8/12
ABC 3 7/25

all i want to see is this

Part Vendor MaxofDate
ABC 1 8/23

can someone explain how to do this for me?

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rank(A1,C1:C5) - Rank using 2 ranges =?Utf-8?B?Z29vZnkxMQ==?= Microsoft Excel Worksheet Functions 3 9th Jun 2006 06:03 AM
Rank where lowest value is highest rank =?Utf-8?B?bWlsZTMwMjQ=?= Microsoft Excel Worksheet Functions 2 9th Dec 2005 11:57 PM
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. =?Utf-8?B?RW1tYW51ZWw=?= Microsoft Excel Worksheet Functions 3 12th Nov 2005 04:33 PM
Rank items, select one start date, have remaining dates follow based on rank rob normerica Microsoft Excel Misc 1 15th Aug 2005 09:36 PM
How to get unique rank numbers when two or more items rank the same. =?Utf-8?B?Q3JhaWcgRC4=?= Microsoft Excel Worksheet Functions 2 26th Mar 2004 10:26 PM




All times are GMT +1. The time now is 05:14 PM.