Return records with lowest value of order number associated with b

[Guest]

I have a record set that lists business names and cooresponding order
numbers. Some companies have just one order, most have several. I would
like a query to return a list of the lowest number of order number, i.e. the
first order. So if they only have one order, then it would return that
order, if they have 3 orders it would return the first or lowest order number.

Much Appreciated,

 

[Pat Hartman\(MVP\)]

Create a totals query that uses the Min() function and returns only the
CustomerID and the Min(OrderID). Then create a second query to join the
first query with the Order table to obtain the details of the order.