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 Smith||08/12/1992||192 (student ID)||test scores||Date taken (date)|
|John Smith||08/12/1992||192||test scores||Date 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