select Instruction

O

Orlando

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.
 
D

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
 
Top