Display all different values

[Charles]

Hi All:

With the help from Ken, I successfully created a query which contains means
for each section and therefore, I am able to calculate the 75th percentile
value (The top 25 th). But now I was asked to display all section means on
the report, too. The data file looks like:

Dept Sec q1 q2 q3 M1 M2 M3
AA 100 2 2 2 2.24 2.24 2.24
AA 100 3 3 3 2.24 2.24 2.24
AA 200 2 2 2 2.63 2.63 2.63
AA 200 3 3 3 2.63 2.63 2.63
AA 200 4 4 4 2.63 2.63 2.63
AA 300 3 3 3 3.14 3.14 3.14
AA 300 4 4 4 3.14 3.14 3.14
BB 100 2 2 2 2.24 2.24 2.24
BB 100 3 3 3 2.24 2.24 2.24
BB 200 1 1 1 2.63 2.63 2.63
BB 200 2 2 2 2.63 2.63 2.63
BB 200 3 3 3 2.63 2.63 2.63
BB 200 4 4 4 2.63 2.63 2.63
BB 300 2 2 2 3.14 3.14 3.14
BB 300 3 3 3 3.14 3.14 3.14
BB 300 4 4 4 3.14 3.14 3.14
CC 100 1 1 1 2.24 2.24 2.24
CC 100 2 2 2 2.24 2.24 2.24
CC 100 3 3 3 2.24 2.24 2.24
CC 100 4 4 4 2.24 2.24 2.24

M1 is scetion means for q1, M2 for q2, and M3 for q3. Now I need to
generate a report grouped by dept but each report should have all section
means. For instance:

Report AA

q1 M1 2.24 2.63 3.14

q2 M2 2.23 2.63 3.14

q3 M3 2.23 2.63 3.14

If I use control expression =[M1], it only displays the first value 2.24.
How can I have all values display on the report?

Thanks for any kind of help.


Charles