Choosing diagnosis based on number within certain range

[The Last Day]

How would I make it so that when I enter a number into a field on a form, Access recognizes the range in which the number is (ex. between 1-10, 11-20, 21-30, etc.) and associates the number with a given description/diagnosis. I'm trying to connect GAF numbers with diagnoses from the DSM-IV Psychiatry manual. If the GAF # is between certain ranges, it relates to a certain diagnosis. How do I do this in Access?

 

[pbaldy]

You can create a table with 3 relevant fields: the lower limit of the range, the upper limit, and the diagnosis. Then you can use any number of lookup methods to get the diagnosis related to any given number; DLookup, query join, recordset SQL, etc.

 

[The Last Day]

I know you think that sounds really simple but I'm such a noob I have no idea how to use any of those methods...