Results in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report only shows the first line of data for each query I've associated
with it.

I have 6 queries that list 6 areas of students' co-curricular achievments.
The queries ask for a student ID number, then report the data for that
student. The report contains all 6 queries (is that correct to do?), and
when run asks for the student ID number. However, when the report is
generated, only the first line of data appears - ex. the query shows Jay
Crew was Dean's List in Feb 05 - Feb 08; the report indicates J. Crew only
received Dean's List in Feb 05.

Thanks for your help!
 
My initial thought is that one would typically have 1 query; that pulls in
the six values logically linked to that one student ID. Merging 6 queries
into one maybe results in a monster query - not sure. You might test as you
go.

So I would restart by creating that query and testing that in simple query
mode to be sure that upon entering the ID that the query results in supplying
the six values needed.

Once that is working right then I would go to Report - New and select the
New Report Wizard to create a report based on that single query.

If you absolutely positively have to have 6 separate queries off a single
student ID - then I'm not clear on where/how the layout is working if there
are no subreports...
 
Back
Top