Slecting Max Date from 1 table

[NBaker]

I have 1 table 'Data' and i need to select the max date. The table contains multiple rows per URN so I need all the fields where the date is most recent.

URN £ Date Gift Type Frequency
164287 £5.00 19/05/1988 Recurring Gift Monthly
164287 £5.00 02/10/1992 Recurring Gift Monthly
164287 £4.00 01/04/2001 Recurring Gift Monthly

Therefore i only need 164287 where the date is highest at 01/04/2001.

i have tried this query below but it still returns mulitple rows and i only require 1 row per URN where the date is most recent?

SELECT Data.[URN], Data.[Gift Amount], Max(Data.[Gift Date]) AS [MaxOfGift Date], Data.[Gift Type], Data.[Gift Instalment Frequency], Data.[Gift Payment Type]
FROM Data
GROUP BY Data.[URN], Data.[Gift Amount], Data.[Gift Type], Data.[Gift Instalment Frequency], Data.[Gift Payment Type];

any help would be most appreciated

N

[PEB]

SELECT Data.[URN], Data.[Gift Amount], Data.[Gift Date], Data.[Gift Type], Data.[Gift Instalment Frequency], Data.[Gift Payment Type]
FROM Data
WHERE ((Data.[Gift Date])=Dmax("[Gift Date]","Data","" ));