AnsweredAssumed Answered

Compare Results of Records with Duplicate ID Fields

Question asked by BG_1 on Jan 7, 2011
Latest reply on Jan 12, 2011 by philmodjunk


Compare Results of Records with Duplicate ID Fields


Hello all,

I'm new to Filemaker Pro and I've run into a problem.

I have a database of pre-test and post-test results, with each record having an ID field.  What I would like to do is be able to is compare the results of each specific pre-test result with that of the post-test.  Some students only took the pre-test, some only took the post-test, and some took both.  Those that took both will appear twice in the database (because of duplicate ID#s).  These are the one's I am specifically interested in. 

Said in another way:

I want to compare John's pre-test with his post-test. I'd like to be able to do this for all duplicate IDs. 

I don't want to compare all pre-tests with all post-tests. 

Thanks very much!