Return records with lowest value of order number associated with b

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

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