Hi Gerard,

SELECT CUS,MAX(Date) FROM customers GROUP BY CUS

MartinaJ


>I have a table as follows with 2 columns :
>CUS Date (Date field)
>A 10 May
>A 12 May
>A 14 May
>B 6 Jan
>B 9 JUN
>B 20 DEC
>
>Is there a Sql select which will select out all customers but with most recent date only
>So I would require:
>A 14 May
>B 20 Dec only
>
>Tia
>Gerard