SELECT Customers.CustomerID, CompanyName, ; MIN(OrderDate), ShippedDate ; FROM Customers ; JOIN Orders ; ON Customers.CustomerID = Orders.CustomerID ; WHERE BETWEEN(OrderDate, {^ 1996-9-1}, {^ 1996-9-30}) ; GROUP BY Customers.CustomerID ; INTO CURSOR FirstOrderThe problem here is that the ShippedDate you get in the result doesn't necessarily come from the order with the minimum order date. (In fact, because of the way VFP's engine works, you get the ShippedDate from the last order in the group.)