grouping reports

[Rocky]

Hi,

I have a column in a table called status. I want to have a group in a
report which groups together data when the status equals, for example,
2,3,5 and in a different group for 1,4,6. Whenever I group by status I
always get 6 different groups instead of 2 for the about example. How
do I get groups for multiple values?

Thanks

 

[Allen Browne]

Create another table to define the groups of statuses (statii?)

Fields:
StatusGroup Number
Status Number

Example data:
StatusGroup Status
1 2
1 3
1 5
2 1
2 4
2 6

By including the StatusGroup table in the query the report is based on, you
can now group by the StatusGroup field.

 

[Ahmad]

you can try to make ([1] & [2] & [3]) as group and ([4] &
[5] & [6]) as group

-----Original Message-----
I would try creating a new boolean column in the

underlying query that uses an IN clause. For example, add
the following columns: