Query with a date filter and Most recent record (1 Viewer)

Chief

Registered User.
Local time
Today, 04:09
Joined
Feb 22, 2012
Messages
156
Hello,
I have a basic report which shows when a client is to be followed up on by a date. It shows when the last contact was and some notes of that contact. The query has a filter 'dates from' and 'dates to' based on the follow up date.
See screen shot of query; Query01.jpg
Works fine and shows all records accordingly.

My problem is; I only want to see the last recorded follow up date for those clients. Not ALL the contact logs for that client. The report will be huge if that was the case.
See screen shot of report; Report01.jpg

Can someone assist please?

Kind regards,
Chief.
 

Attachments

  • Report01.jpg
    Report01.jpg
    62.1 KB · Views: 106
  • Query01.jpg
    Query01.jpg
    71.8 KB · Views: 126

JHB

Have been here a while
Local time
Today, 13:09
Joined
Jun 17, 2012
Messages
7,732
Can't you use a Max on the "Followupdate". It is the Sigma-sign in the Query design menu.
 

Users who are viewing this thread

Top Bottom