What is the best way to query the most recent entries in my access database?
If I have one table for cognitive assessment and patients are added to the table as they come in from year to year, they will have multiple records in this table.
How do I run a query to pull all people from the patient information table (the entire cohort) and their corresponding cognitive information without duplicates (only pull the single most recent record from cognitive assessment)?
Here's an example of a subquery to provide what you need
SELECT PatientEval.Patient, PatientEval.EvalDate, PatientEval.Eval FROM PatientEval WHERE (((PatientEval.EvalDate)=(select max(EvalDate) from PatientEval T where T.Patient=PatientEval.Patient)));