Selecting unique records only 1

[BlueOfficeHead]

Hello,

I'd like to select the ID, Query and Date from my table,
but would like to see only the unique records based on fldQUERY fields. So if 2 instances of the fldQUERY are the same regardless of any other fields, only one of them would be returned. Is there a way to do so ?

SELECT ID, fldQUERY, fldDATE FROM tbl_google ORDER BY fldDATE DESC

 

[PHV]

Something like this ?
SELECT Max(ID) As myID, fldQUERY, Max(fldDATE) As myDate
FROM tbl_google GROUP BY fldQUERY ORDER BY 3 DESC


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244