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