By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Need help in ranking

P: 1
I have a table with a field "item code". Each item code appears 4 times with "price" of 4 vendors. Like this I have 100 item code (ie. I have 400 records). I want to rank the price of the 4 vendors for each item code.
Can someone help
Oct 5 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
hi ,

If you want to arrange your data, first the products and then the prices by vendor, so

Go in query design,

Invoke your table,

Choose your product item column by clicking twice on it...

Under it, assign sort Ascending

Choose the column of vendor... Choose ascending also!

At last do the same with the prices...

Now you are ready to open your query in datasheet view and to see the results!

Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.