How to use range categories in an access query Nekodvoru 01.08.2006 18:33:02 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

RE: How to use range categories in an access query Klatuu 01.08.2006 20:20:02 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) "Nekodvoru" wrote: [Quoted Text] > 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