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!

Edited by lowester - 30 Sep 2011 at 9:30am