Last order only for a list of customers

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

Guest

I'm trying to figure out how to pull only the last order for a group of
customers. I have the customers phone numbers in a query and am matching
them to my order header table. I just don't know how to filter out multiple
orders to where it only shows their last order number instead of all of their
orders.

Thanks,
Billy
 
Try doing a query that lists the times, date in a descending fashion.
You could even to a MaxOfOrderID (or whatever) and select TOP 1.
 
Back
Top