How to use range categories in an access query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nekodvoru - 01 Aug 2006 19:33 GMT

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

Reply to this Message

Klatuu - 01 Aug 2006 21:20 GMT

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)

> 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
[quoted text clipped - 9 lines]
> Eugene
> NY

Reply to this Message