To keep control of records I am using... lLastRec=gPage*gRows ...and then SQL statement... SELECT * FROM Titles WHERE ROWID >0 AND ROWID <= lLastRec ORDER BY num The SQL error 'No such column lLastRec' suggests a variable cannot be used to compare ROWID. Having replaced it with a number and it works seems to confirm this. This obviously presents a problem when trying to obtain sets of data to display one page at a time to avoid having scrollbars appear on the Table. It means a number must manually be provided per page. I must have something wrong here.