To Remove Duplicate Values

system · September 18, 2009, 2:48pm

Hi,
I have a following table

clientid Appdate
101 11/05/2009
101 12/07/2009
101 13/09/2009

i want to get rid of the duplicate values of client id and to get the recent date of AppDate in the report.
Any solutions Please
Thanks in Advance
Deep

pdeep (BOB member since 2007-05-31)

system · September 18, 2009, 11:59pm

Group on Client ID
Create a Summary for AppDate, ie, Max(AppDate), apply for all groups and place the Summary in the Group Header.
Suppress Detail.

AnthonyJ (BOB member since 2006-06-30)