How to use range categories in an access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOw could I break down column of values into categories base on preset ranges
of these values and disply the correspning to these ranges categories
For example


<25,000 category I

25000< but <50000 category II

50000< but <250000 category III

Thank you
Eugene
NY
 
If what you are asking is how to have columns for each category, create 3
calculated fields in your query, one for each query.

Cat1: IIf([SomeField] < 25000, [SomeField], Null)

Cat2: IIf([SomeField] > 25000 And [SomeField] < 50000, [SomeField], Null)

Cat3: IIf([SomeField] > 50000 And [SomeField] < 250000, [SomeField], Null)
 
Back
Top