grouping reports

  • Thread starter Thread starter Rocky
  • Start date Start date
R

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
 
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.
 
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
Click to expand...
underlying query that uses an IN clause. For example, add
the following columns:
 
Back
Top