DerryLyons
asked on
Access multiple outer joins
I have a user wanting to convert a flat FileMaker Pro database into Access. The database (which is attached) tracks students and different "matrix logic" tests they have completed, and the user is accustomed to seeing ALL of the tests, and dates filled in as the tests are completed. I'm able to outer join the "test list" to the "completed list", but outer joining that to the "student list" won't show the non-taken tests. I've wracked my brain but can't get this to pull through (and it's not helping my marketing efforts of why Access is better than FileMaker!)
ml.mdb
ml.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Joe Overman
Mike77 took the words right off my keyboard. Good job.
ASKER
That will do the trick! Looks like I was trying to join the tables together too soon, then not thinking about a compound left join later. Thanks!!