Max Date with Additional Info

ewong1

Eric Wong
Local time
Today, 02:34
Joined
Dec 4, 2004
Messages
96
Here is my query:

SELECT IDTank, MAX(dtmDate), ysnSterilized, ysnDetartrate
From tblCleaned;

This query is not returning only the records of my MAX(dtmDate) function. How do I enable the query to show the sterlized and detartrate information from the check boxes without including old records? Thanks for your help!
 

Users who are viewing this thread

Back
Top Bottom