greater than & less than sorting

[Guest]

I want to create a Report, by grouping values from a query, by using seperate
expressions of X<=3, 5.5>=X>3, or X>5.5. I want to group these three
expressions in the Report
stormnnorman

 

[Douglas J Steele]

In your query, you can add a computed field along the lines of:

SortField: IIf([X] <=3, 1, IIf([X] <= 5.5, 2, 3))

If you want the text, you'd also need:

GroupText: IIf([X] <=3, "X <= 3", IIf([X] <= 5.5, "5.5 >= X > 3", "X >
5.5"))