Hi,

We have a database of all our patients and their test results from different dates. We are trying to get the most recent result for each patient but can't find a way of doing it.

We can currently get all results for all patients (where they appear on different lines) . Can I suppress all but the most recent?

I'm wanting to export it to excel for the stats so don't really want to have a group title at the top of each patient of name, date of birth etc to separate patients (unless that can be filtered out later).

Does anyone have any ideas how to do this?

Thanks