Retrieving dat with recent date

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

Guest

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
 
Use a totals query:

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