Access_Help
Registered User.
- Local time
- Today, 08:26
- Joined
- Feb 12, 2005
- Messages
- 136
Hi,
I need a query that takes a score as an input, compares the score with the different range values and returns the level (L1, L2, L3)
I am not sure how to achieve a VLOOKUP type function.
Any advice so that I dont have to type every single value for each range.
I need a query that takes a score as an input, compares the score with the different range values and returns the level (L1, L2, L3)
I am not sure how to achieve a VLOOKUP type function.
Any advice so that I dont have to type every single value for each range.