finding the most recent date

[dsundy2003]

Hi there

I have a table with 2 fields, and say 3 rows (to keep it simple)

Customet No. Date
-------------- ------
001 1/1/2003
002 30/12/2003
003 15/7/2003

How do I write a query to retrn the customer No and the date for the largest date. In the above example, it will return 002 and 30/12/2003. I tried using the MAX function on the 'Date' field, but it doesnt work.
I have a more complicated query with more variables, but this step is holding me back.

Pls advise

Darryn

 

[WillR]

Can you post up the SQL code ?

I have something similar that gets a groupid and "latest record date" using MAX and it works fine..

Heres my SQL - see if it helps

SELECT dbo_grup.id, Max(dbo_gchg.effective) AS MaxOfeffective
FROM dbo_grup INNER JOIN dbo_gchg ON dbo_grup.rowno = dbo_gchg.rowno_grupgchg_grup
WHERE (((dbo_grup.id)=[dbo_gchg].[id]))
GROUP BY dbo_grup.id;

To view, got view SQL View

Hope this helps