query - max ID number

SELECT Max(ID), Table.[Date]
FROM Table
WHERE Table.[Date] = Date()

By the way terrible name for a field. Date is a function returning
today's date (or at least the system date on your computer)

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Pass-the-reality wrote:
> I have a query that returns all the records with today's date. Within the
> query, I also return all the record Auto ID numbers. What do I need to add
> to this query so that it will only return the max auto ID number. For
> example - I only want line 1235 to show as it is the largest ID number.
>
> ID Date
> 1233 December 31, 2008
> 1234 December 31, 2008
> 1235 December 31, 2008
 >> Stay informed about: query - max ID number