Last order only for a list of customers

[BillyRogers]

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

 

[poppybush]

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.