comparing values from two tables - Inner Join
I really need help! I have to present a FMP and Access solution in a couple days. I have Access working, but can't get FMP to work. (ironicly I love FMP, but not Access). I need to report a comparision of student test results from two different years. Here is the setup.
3 tables: Student Demographics, 2010 test results & 2011 test results. The test results have reading, math & science scores.
Key field: Student ID
I want to only show the reading scores for each student when the student had results from both years. So if a student had a 2010_test:reading_score and 2011_test:readingscore, print the student name the the two reading scores.
Any help will be greatly appreciated.