Date query

G

glnbnz

I want to make a date query. I have multiple records that are the same
except with different dates. How would I write a query that would display
the last date? So in the query table there would be a single record with the
latest date.

Thanks
glnbnz
 
G

glnbnz

Thank you very much that worked very well.

glnbnz

Dale Fye said:
SELECT MAX([DateField]) as LatestDate
FROM yourTable

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.


glnbnz said:
I want to make a date query. I have multiple records that are the same
except with different dates. How would I write a query that would display
the last date? So in the query table there would be a single record with the
latest date.

Thanks
glnbnz
Click to expand...
Click to expand...
 
Top