Date query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Latest Record 2
Dcount returning no results!!! 0
Totals query and Memo field 3
Combine Duplicates in Query 0
#error - Blank 3
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1
Crosstab Query based on Query 4
limit query results based on 2 date fields 2

Back
Top