Retrieving dat with recent date

[Naveen]

Hello,
i have a database with serial no and date as fields. The serial number is
say the number of a event or job. The progress on the job with a serial
number is recorded daily. My requirement is that i want to design/ write a
query that gives me the latest update on a particular job or latest update on
all the jobs. I have been able to sort the jobs by latest date but have not
been able to write a query to retrieve the same and ouput it to a report. How
can i do it.
Thanks
Naveen

 

[Ken Snell [MVP]]

Use a totals query:

SELECT [serial no], Max([date]) AS DateOfLastEntry
FROM tablename
GROUP BY [serial no];