By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Split Query Result - How to combime them together?

P: n/a
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?

Oct 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

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.

Oct 26 '06 #2

P: n/a
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

Oct 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.