select Instruction

[Guest]

Hi, there is a way to build a SELECT where I can get the next or previous 10
or 15 records, no mather what is the record.

Thanks.

 

[Damon Heron]

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