AnsweredAssumed Answered

Summary report problem

Question asked by on Nov 20, 2009
Latest reply on Nov 20, 2009 by


Summary report problem


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:



  John Smith



  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).