How to Query Most Recent Invoice for Each Customer

[Mike Schumann]

I have a database containing customer invoices. Each record includes the
CustomerID, the InvoiceDate and other fields.

I would like to create a query that returns only the most recent invoice
record for each customer.

Can anyone explain the simplest way to do this?

Thanks,

 

[Michel Walsh]

Hi,


Take one of the 4 solutions presented in
http://www.mvps.org/access/queries/qry0020.htm, about finding the last
borrower for each book, in a library.


Hoping it may help,
Vanderghast, Access MVP