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.
 
Back
Top