Expression HELP!!

[pwoodj]

Ok, I have a query that has a range of number for 1 - 126, I need and an expression that will flag sub-ranges in the list of numbers.

Example I want to group or flag results 0-25 as one group, 26-50 as another, 50 - 75 and 76 -100.

Any ideas? I statred with an IF than expression, but I can't figure how to indicate each range.

thanks
-pete

 

[statsman]

Try
Group1:[fieldname]
in criteria
>0 and <26

etc.