Query to find last entry of date

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have an contact history table that contains a variety of
fields including contactid and completedate. The
completedate is automaticaly populated with a date when a
new history record is added.

I now what to write a query that pulls from this table the
last entry, based on completedate, for each contactid.

How do I do this?

Thank you in advance for you input
 
Create a query based on your contact history table. Only include the fields:
ContactID
CompleteDate
Click on the Sigma (looks like E) button on the toolbar at the top of the
screen. Under CompleteDate, change GroupBy to Max.
The query will return the most current CompleteDate for each ContactID.
 
Back
Top