AnsweredAssumed Answered

Specifying Data for Lookup

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

Title

Specifying Data for Lookup

Post

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 

Outcomes