Infinite
More left to learn.
- Local time
- Today, 08:14
- Joined
- Mar 16, 2015
- Messages
- 402
So, I have a table with 3 columns.
Item____Cost1___Cost2___Cost3
One_____$10____$14____$2
Two_____$3_____$17____$15
Five_____$1_____$6_____$7
What I would like to do is get something to get me the top of those. That something can be a query or a SQL code. Anything in access will work for me.
So, let's look at Item 1. I want it to get me the value under Cost 2 because Cost 2 has the highest value for Item 1.
For Item 2 I would want also Cost 2 because again, Item 2 has the highest value.
With Item 5 I would want the value under Cost 3 because, for this item, Cost 3 has the highest value.
Any way to do that?
Item____Cost1___Cost2___Cost3
One_____$10____$14____$2
Two_____$3_____$17____$15
Five_____$1_____$6_____$7
What I would like to do is get something to get me the top of those. That something can be a query or a SQL code. Anything in access will work for me.
So, let's look at Item 1. I want it to get me the value under Cost 2 because Cost 2 has the highest value for Item 1.
For Item 2 I would want also Cost 2 because again, Item 2 has the highest value.
With Item 5 I would want the value under Cost 3 because, for this item, Cost 3 has the highest value.
Any way to do that?