This is a migrated thread and some comments may be shown as answers.

Displaying distinct records in grouping

0 Answers 112 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Charl
Top achievements
Rank 1
Charl asked on 23 Jan 2012, 12:53 PM
Hi
How can I get distinct records in grouping?
ie. I have the following report that is displayed.

Co. Number          Date
---------------          ----------------
111                       2011/12/01
111                       2011/12/02
111                       2011/12/03

222                      2011/12/07

333                      2011/12/09

I want it to display as follows
Co. Number        Date
---------------        -------------------
111                     2011/12/03

222                     2011/12/07

333                     2011/12/09

showing the latest record for each Co Number

Kind Regards,
Charl van Tonder

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Charl
Top achievements
Rank 1
Share this question
or