[RESOLVED] database in ms access

hello!
i have these values in access database using vb6

field1 field2
a 05/06/2007
a 05/09/2007
b 05/11/2007
b 05/20/2007

i want output like this:(getting the max date and distinct)
a 05/09/2007
b 05/20/2007

i tried DISTINCT and MAX(field2) unfortunately it doesn't work

pls help me to solve.
tnx

Code:

---

SELECT Field1, Max(Field2)
FROM YourTable
GROUP BY Field1

---

What do you want it do???

TNX! bushmobile!

the only keyword there is GROUP BY
tnx again.