I'm not thrilled with First and Last; would use Min and Max instead.
They have a more solid SQL underpinning.

Using the Northwind sample database:
List of customers with the first time they ordered productid=1:
SELECT Orders.CustomerID, Min(Orders.OrderDate) AS MinOfOrderDate
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order
Details].OrderID
WHERE ((([Order Details].ProductID)=1))
GROUP BY Orders.CustomerID;
Save this as query Q1

Here is Q2: the list of subsequent orders
SELECT Orders.CustomerID, Orders.OrderDate
FROM Q1 INNER JOIN Orders ON Q1.CustomerID = Orders.CustomerID
WHERE (((Orders.OrderDate)>[MinOfOrderDate]));

Q3: Minimum subsequent order:
SELECT Q2.CustomerID, Min(Q2.OrderDate) AS MinOfOrderDate
FROM Q2
GROUP BY Q2.CustomerID;

Q4: The products purchased in the subsequent order:
SELECT Orders.CustomerID, Products.ProductID, Products.ProductName
FROM Q3 INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order
Details] ON Orders.OrderID = [Order Details].OrderID) ON
Products.ProductID = [Order Details].ProductID) ON (Q3.MinOfOrderDate
= Orders.OrderDate) AND (Q3.CustomerID = Orders.CustomerID);

-Tom.