How to Query Most Recent Invoice for Each Customer

  • Thread starter Thread starter Mike Schumann
  • Start date Start date
M

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

eliminating duplicate records in select query 1
GROUP BY question 1
Searching for Missing Data 1
Only show most recent invoice? 2
Show Invoices Greater Than One Year 8
manual deletion of records in datasheet based on joined tables 5
How do I display 1 line per Invoice Summary w/totals from Invoice Detail ? 4
query to pull most recent record by date 1

Back
Top