Hi, I have a database full of clients and events.. Example client 123 had and event on 08242011 in an Outpatient Program. Im trying to pull the last event each client had.. Example if client 123 had 3 events.. 1 in june, 1 in july, 1 in august.. i want the report to show only the 1 for august since is that most recent event. Looking for some guidance on how to do this.. thanks!
There are also other clients in the database and want the report to pull the most recent event for each individual client..
IP Logged
