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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Else statment Help 5
Trying to combine multiple records into one record in a Query 1
OpenRecordset method is gutting query 1
Calculating a date within the OLE DB query 1
SQL Query between 2 dates 5
Setting Values to Null or False Using a Update Query 2
calculate average ? 2
relationships/ tables 2

Back
Top