grouping reports

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
 
A

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.
 
A

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top