Query for most recent record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form/table for customers and one for orders. They share a common id.
When I run a query to join them, I get multiple records for each customer
depending on the number of orders they have placed. Is there a way to have it
only return the record with the most recent order? I cannot limit by dates,
because customer #1 might have placed last order 1 year ago, while customer
#2 may have placed 15 orders during that time. I only need the most recent
orders per customer for my report. Sorry, but I'm not incredibly
knowledgeable in access, so any assistance would be greatly appreciated.
 
Try sorting your customers in ascending order and the dates in
descending order. That way the most recent order appears at the top.
 

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

Query for most recent order.... 1
most recent 5 records 3
Most Recent Record in a set 1
Most recent date function 2
jumping data 1
combobox population record dependent 4
delete query 1
E-Buyer - my recent experience 10

Back
Top