SELECT Max(CartID) AS maxOldCartID FROM Carts WHERE CartDate < #DateAdd("d", -1, Now())# DELETE FROM CartItems WHERE CartIDReference <= #maxOldCartID# DELETE FROM Carts WHERE CartID <= #maxOldCartID# INSERT INTO Carts (CartDate) VALUES (#Now()#) SELECT Max(CartID) As NextCartID FROM Carts UPDATE Carts SET cartCookie = #GetCartID.NextCartID# WHERE CartID = #GetCartID.NextCartID#