How do I rank a non alphabetical list box in a lookup?

T

Ted

I have a listbox where the names aren't in alphabetical
order.. but still need to be ranked in a lookup..

I've entered them in the listbox in the proper order from
highest to lowest

Actually they are the grades of diamonds and go from
Flawless, Internally Flawless.. VVS1 VVS2 SI1 SI2 I1 I2 I3

When I do a lookup will access know what is highest to
lowest based on their position in the listbox enabling me
to look up ranges etc..

Thanks......
 
J

John Vinson

I have a listbox where the names aren't in alphabetical
order.. but still need to be ranked in a lookup..

I've entered them in the listbox in the proper order from
highest to lowest

Actually they are the grades of diamonds and go from
Flawless, Internally Flawless.. VVS1 VVS2 SI1 SI2 I1 I2 I3

When I do a lookup will access know what is highest to
lowest based on their position in the listbox enabling me
to look up ranges etc..

Thanks......
Click to expand...

I'd suggest creating a Table with two fields - a numeric field Rank
and the text Grade. Base your combo box (DON'T use the Lookup
misfeature in your table... just use the combo on a Form!) on a Query
sorting the records by Rank.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top