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.
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.