Grouping

dl41001

Registered User.
Local time
Today, 18:54
Joined
Apr 18, 2001
Messages
17
Hi - I would like to have a column in a report grouped as 1-100, 101-1000 and 1001-up (not interval)
Pls show me how to do it.
Thanks.
 
You'll need to create a field in the query for the report to group on.

Select IIf(YourField < 101,"A",IIf(YourField > 100 and YourField < 1001,"B","C"))
As GroupName, ....
I chose the letters A, B, and C. You can use whatever you want.
 
Pat, thank you so much. It helped.
 

Users who are viewing this thread

Back
Top Bottom