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)?

Answers


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)));

Need Your Help

Communicate between two devices using Apache Thrift

client server thrift

Heads up: I'm a beginner when it comes to web development and networking.

List files in sdcard returns Null

android file-listing

I'm working on modifying Android framework and trying to add a module to check files in sdcard as follows: