I was wondering if someone could kindly help me with a potential way forward
I am using example data but the concept is real. I would like to retrieve the last 3 records for each patient in a load script table i
Patient Number Date Test
123 01/01/2020 1
123 02/01/2020 1
123 03/01/2020 1
123 04/01/2020 1
123 05/02/2020 1
The records I would like to be returned are highlighted in bold. Before I go down a rabbit warren of possibilities I.e. using the peek function, loop functions etc, I was wondering if there is a function built in which I could use to retrieve the last 3 records per patient
If you have come across something similar in the past, a helpful hint would be gratefully appreciated
Helen, just a gentle reminder to not forget to return to your thread and close things out... I am guessing the sample app likely worked, if so, please be sure to use the Accept as Solution button on that post to mark it as the solution, which will give credit to the poster for the help and let the other Members know it worked. If you still need further help, please leave an update.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.