I want to have Filemaker to look at the last field in this group and see if it has information in it. If it does it will fill in that info on another template automatically. If not it will go to the previous field and do the same check until it finds the students last test result and then it will use that.
Assuming the each rank field contains a single value, this calculation returns the value of the last NOT empty field:
values = List ( Rank1 ; Rank2 ; Rank3 ) ;
GetValue ( values ; ValueCount ( values ) )
Wow! That was fast! It works perfectly. Now, is there a way to add that last part about the new rank being picked along with the last rank? This would show on the new template that I print out with their rank before the test and after the test. I'm guessing I just need to create another field like you did with VALUES and use the compare dates function with it. Either way you are great and I thank you! Would it be possible to pick your brain on a few more of my program hang-ups?
Sorry, I don't think I was clear on that last post. Your solution works fine until I enter the newest rank (test) grade and then it becomes the old rank unless there is someway to do your search with the current date involved and without. Now my english is failing me ! Hope I'm making myself clear but if not I'll try again.