AnsweredAssumed Answered

comparing values from two tables - Inner Join

Question asked by wawman on Mar 29, 2012
Latest reply on Mar 30, 2012 by philmodjunk


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.