Access: Finding the Highest Record in a field Using a Query

[klmorgan]

Is it possible to find the highest dated record using a standard Query ie.


In a table of invoices find a record that finds the last record for a person

Name Invoice Date
= "Morgan" =Highest Date

I've looked through the operators and can't see one to fit.

Regards

Keith

 

[jrbarnett]

By "Highest Date" I presume you mean newest.

Something like the following SQL will bring it up for every customer:

SELECT customername, max (invoice_date) As LatestInvoice
FROM yourtable
GROUP BY customername
ORDER BY customername

To bring up the latest for just one specified customer:

SELECT customername, max (invoice_date) As LatestInvoice
FROM yourtable
WHERE customername = [Enter Customer Name]
GROUP BY customername

John