It's that simple, imagine table with one field - DATE. it has 3 records, 8/30, 8/30, and 8/28. How do I build the query to select only the latest date (in this case 8/30 so the final outcome would be 2 records)
but that would only show the max date; it wont show the associated ID field; if u try doin max on date with ID field, it wont show max date;
if ur tryin to get the ID associated with the max date, you can make a query with the info above this (max date) and then in a new query, link ur table date field to the date field from the queyr, and u can get ur file numbers.
I dont think thats the fastest way, there might be a faster way?