J Joe168 Jun 24, 2009 #1 I have a query with a date field. How do I write in the criteria to retrieve the record with latest date? Thanks! Joe
I have a query with a date field. How do I write in the criteria to retrieve the record with latest date? Thanks! Joe
M Marshall Barton Jun 24, 2009 #2 Joe168 said: I have a query with a date field. How do I write in the criteria to retrieve the record with latest date? Click to expand... SELECT TOP 1 table.* FROM table ORDER BY thedatefield DESC
Joe168 said: I have a query with a date field. How do I write in the criteria to retrieve the record with latest date? Click to expand... SELECT TOP 1 table.* FROM table ORDER BY thedatefield DESC
