Hi there,

I am just trying to display the last date something hasbeen worked on!


I have grouped by contract number

and then there may be a series of dates that work may have been completed on this contract but the last date is the only relvant date I want to display!

So my data crrently looks like this

Contract Number
                                 Contract manager  Date Started  Work last completed
                                    Bill Smith                 Nov 08                        August 09
                                    Bill Smith                 Nov 08                  September 09
                                    Bill Smith                 Nov 08                         March 10


is there an easy way just to show that last date?

Thanks


New it was simple

IMuch apreciated

Regards

Leith