Hi,

I am attempting to run a query that returns the most recent date, less on

i.e. in the following list the value 29/02/2004 would be returned, not because its the most recent value, but the value before the most recent value.

30/02/2004
29/02/2004
28/02/2004
27/02/2004
26/02/2004

I currently have the SQL:
SELECT dbo_tblDocuments.dCustomer, Max(dbo_tblDocuments.dDate) AS [Date of Last Order]
FROM dbo_tblDocuments
GROUP BY dbo_tblDocuments.dCustomer;

(where the field 'dCustomer' is the Customer's unique reference.)

HOW ON EARTH do I get the most recent value -1 to show?

Many thanks
Martyn
London