Query for most recent record.

[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.

 

[Penguin]

Try sorting your customers in ascending order and the dates in
descending order. That way the most recent order appears at the top.