Thanks, tried this as follows:
SELECT T.Year, T.OrderNumber, T.SumOfQuoteValue, DCount("*","qryMaintOrderContractYearTotals","Year < " & T.Year) AS Sequence
FROM qryMaintOrderContractYearTotals AS T
WHERE (((T.OrderNumber)="MJ0092762"));
But get the following results which aren't right...