Query by Latest Date? (1 Viewer)

I have a table that contains two columns, Sample_ID and Test_Date.

Each Sample_ID can be tested perodically over a period of months. Sample_ID is part of a finite set. I would like to be able to write a query such that I get a list of individual Sample ID's (no duplicates) and the most recent date they were tested... is this possible just using a query?

Thanks!!

tkpstock,

When I need to accomplish this I use the "Last" or "Max" option in my query Total field. This pulls the data for the latest date for each record.

Toni

Oh my, that was such an easy answer, I'm embarrassed. I was trying the Max function but was getting aggregate function errors on other fields. When I backed out and re-did everything, it worked just fine.

Thanks!!