Missing records in reports

[StevenC]

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

[Lee Smith]

Hi Steven, and Welcome to the Forum,

I don't think we have enough information to help. Without seeing a copy of your file, I would guess that your relationship isn't correct, and/or you have set up your report wrong.

To attach a copy of your file, take a look at this post, Link

Lee

[Peter (duksis3)]

To reflect all relative students, use portal.

[StevenC]

Yes, Lee. You are absolutely correct. I had set it up wrong. I don't want to bore you with the details, but I finally figured it out. I wasn't pulling from the correct tables consistently. It was the fact that it was sort of working that bugged me. I would have thought it would be all or nothing if I botched it.

Steve.