D dl41001 Registered User. Local time Today, 18:54 Joined Apr 18, 2001 Messages 17 Oct 26, 2001 #1 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.
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.
P Pat Hartman Super Moderator Staff member Local time Today, 13:54 Joined Feb 19, 2002 Messages 47,859 Oct 26, 2001 #2 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.
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.
D dl41001 Registered User. Local time Today, 18:54 Joined Apr 18, 2001 Messages 17 Oct 28, 2001 #3 Pat, thank you so much. It helped.