You mean where there is a parameter entry -a record number?  then something
like this:

SELECT tblTransactions.TransactionID, tblTransactions.Date
FROM tblTransactions
WHERE (((tblTransactions.TransactionID) Between [?]+10 And [?]-10));

Damon