AnsweredAssumed Answered

Specifying Data for Lookup

Question asked by comfortfalcon on May 20, 2015
Latest reply on May 20, 2015 by philmodjunk


Specifying Data for Lookup


Hello, i'm developing a database for an afterschool program and I am having some issues. My problem is trying to import test scores from an online resiliency test. The data imported has a similar format to this.

John Smith08/12/1992192 (student ID)test scoresDate taken (date)  
John Smith08/12/1992192 test scoresDate taken ( late date  

I need to look at the pre and post test scores and find whether or not they improved. I just don't know how to tell filemaker to search for which entry has an earlier date for pre test scores, and which one has a later for Post test scores. The program the grades everything must have been written in the 90's so i have no customization on that side. Also i'm using FileMaker Pro 13. So far i really like this program, i just wish i had like sql "select from where" statements