Split Query Result - How to combime them together?

[asianstreet]

How do you NOT display a field when the record is not selected?

School Name: AAA BBB CCC DDD or ALL Schools

when i select AAA, the result would be only:

Student: GPA School Name
Tom 3.5 AAA
Chris 2.0 AAA

when i select all school, this is what it appears:

Student: GPA School Name

Tom 3.5 AAA
Tom 3.0 BBB
Tom 3.5 CCC
Nick 2.0 DDD
Chris 3.5 BBB
Chris 2.0 AAA

what I WANT is:

Student: GPA School Name

Tom 3.33 ALL Schools
Nick 2.0 ALL Schools
Chris 2.75 ALL Schools

How to i set up the query so that I can get the result?

[pietlinden]

as*********@yahoo.com wrote:

How do you NOT display a field when the record is not selected?

School Name: AAA BBB CCC DDD or ALL Schools

when i select AAA, the result would be only:

Student: GPA School Name
Tom 3.5 AAA
Chris 2.0 AAA

when i select all school, this is what it appears:

Student: GPA School Name

Tom 3.5 AAA
Tom 3.0 BBB
Tom 3.5 CCC
Nick 2.0 DDD
Chris 3.5 BBB
Chris 2.0 AAA

what I WANT is:

Student: GPA School Name

Tom 3.33 ALL Schools
Nick 2.0 ALL Schools
Chris 2.75 ALL Schools

How to i set up the query so that I can get the result?

You mean somehow not show School Name? Just group by Student and don't
include School name in your query at all. Maybe you can use
fConcatChild from AccessWeb to concatenate all the school names (if
that's what you're loking for.) Otherwise, you could put the Avg(GPA)
part in the Student header of your report and then the school/school
GPA in the detail section of your report. If you go that route, you
could show/hide the school info... but that's going to require some
code.

[Vincent]

what I want is group by Students only when no school it's selected.
That means finding the average gpa of the student in all schools. If a
school is selected, show only the average gpa of that school only