AnsweredAssumed Answered

Summary report problem

Question asked by sac@aol.com on Nov 20, 2009
Latest reply on Nov 20, 2009 by sac@aol.com

Title

Summary report problem

Post

Without giving too many details that may be extraneous. I have a db that tracks student applications to schools. I want a report that lists each school followed by all the students applying to that school. Basically, I want a report that lists all the records in my "applications" table and groups them by school. I can do this, but the report only lists the first student record for each school (though there are other students applying). For example, imagine that there are 10 students applying each to Harvard and Yale. The report currently returns:

 

Harvad

  John Smith

 

Yale

  Jim Jones

 

The other 9 students applying to both schools are missing. Any thoughts? (I have the same problem when I want a similar report except grouped by students to give me a list of all the schools each student is applying to). 

Outcomes