Search and display the latest date for a record 1

[palmettokid]

I use an access datatbase to track employee attendance and training.  I would like to know how to have a query display the latest date from a grouping of employee records. For example: the last date an employee took a re-occuring certification course.

 

[DougP]

Do you know how to make a query?<br>Add the field that has the &quot;re-occuring certification course&quot; in it.<br>Then add the date field for that course then sort the date field Descending, the last date will be at the top...

 

[Jonathan]

There are various options for grouping and summarising data in the query editor.&nbsp;&nbsp;For example, following on from your own example, it would be possible to select the employee, course and date from the relevent tables, group the data by employee and course, and then return the maximum date for each employee and course.&nbsp;&nbsp;In the query editor, select <i>Totals</i> from the <i>View</i> menu to display the Totals line, which will allow you to specify your options for summarising data.<br><br>Hope this is of some help.&nbsp;&nbsp;If you need any more suggestions, post with some more specific info about what you are looking to do.<br><br>Jonathan <p> Jonathan<br><a href=mailto:j.w.george@virginnet.co.uk>j.w.george@virginnet.co.uk</a><br><a href= > </a><br>Working with: Visual Basic 6, Access 97, Visual Interdev 6, VBScript, Active Server Pages, SQL Server 6.5, Oracle 7, users who really have no idea what they want...

 

[bjo]

Looking at this website makes me realize I am definitley a novice.&nbsp;&nbsp;I was having a similar problem with dates. Setting up an HR/Payroll database, I have downloaded &quot;pay history&quot; and &quot;job title history&quot; from a non Y2K software to Access.&nbsp;&nbsp;I need to run a report with the current rate and title.&nbsp;&nbsp;I currently have a query, form, and report listing the employees with ALL the history and the most recent is on top, but how can I list ONLY the most recent date (and in return most recent rate and job title) on the report.&nbsp;&nbsp;I will look at the summarizing suggestion, but I'm not sure if that is what I'm looking for.&nbsp;&nbsp;