I am exporting patient’s exam data from a SQL database via ODBC. I want to be able to find out the patient’s most recent exam date from the data I have gathered. The patient may have had 4 exams over the last 4 yrs, or they may have had only one. I need to filter out the most recent exam so that I may then calculate the elapsed time since their last exam. I am currently using a pivot table. Any tips would be appreciated...