So here’s where i’m at: i have a repeating group displaying the scores from five DB entries that have a particular field in common called ‘TotalScore’. As you can see in the picture below, i sorted them by creation date and set it to ‘items until #5’. Although i have have been able to do this, the problem i am having is that I don’t just want to get the last 5 ‘totalscores’ i want to make sure it is only one score from each of the 5 total score types (“quiz”). In its current state its possible that instead of getting the last score for questionnaire 1, 2, 3, 4, & 5 (which is what i want), it may just pull up (e.g.) questionnaire 3, 4, 5, 5, 5 instead (because if questionnaire five was done three times then quiz 3,4,5,5,5 would show up when searching for ‘items until #5’).
Please help me figure out how to make the repeating group take the LAST SCORES from each QUIZ. In other words how do i not just search the database for entries with with ‘totalscore = yes’ but also for last of each of the five quizzes. Hope i’ve repeated myself enough for that to make sense. Thanks in advance. Any help or ideas would be great.
So far i have been able to make a repeating group display 5