How do I the last record in a table

**Softweb** · 03-06-2015, 12:52 PM

I have an Access database that has a Client table and an Appointment table. Clients can has one or more appointments. I need to produce a Query that pulls out the latest record for each Client. Any help on how to do this would be really appreciated.I have an Access database that has a Client Table and an Appointment table. Clients can has one or more appointments. I need to produce a Query that pulls out the latest record for each Client. Any help on how to do this would be really appreciated.

**JoeM** · 03-06-2015, 01:05 PM

Take look at using an Aggregate (Totals) Query.

You will "group" on the Client ID, and return the "max" value for your appointment date.
If you want to get the other details from that record, link this Aggregate Query back in with your data tables, joining on the Client ID and appointment date fields.

**June7** · 03-06-2015, 01:07 PM

Another approach is TOP n, review http://allenbrowne.com/subquery-01.html#TopN

**Softweb** · 03-07-2015, 12:06 PM

Many thanks

How do I the last record in a table

Thread Tools

How do I the last record in a table

Similar Threads

Update first null record in a Scheduling table with Current Record's ID number in "Main" table

VBA Coding Append new record in one table and copy data from another table to new record

Product entry form- duplicate last record in table/copy/paste in new record

select record on multi item form and add that data as a new record in another table

Using VBA to get data from a parent table record to a child table record (address)

Posting Permissions