Selecting Distinct Record

[Bob-PA]

I have a table - the key is made up of 2 fields (Client ID and Session Date). I want to create a query to select the latest record for each client. That is, if I have 3 records for client A123, with dates of Jan-1-2001; Feb-2-2001; and Mar-3-2001; I only want to select the record with the Mar-3-2001 date. Can anyone help me to do what I want? Thanks for any asistance.

 

[shacket]

Click the Sum button (the Sigma in the toolbar) and choose "Max" on your Session Date field.