I have a TABLE called CUSTOMERS which contains two fields, CUST_ID and CUST_NOME (it is a MS Access database).
It has almost 1000 records.
How can i implement this: when the user click in a button, he just see the fields 1 to 10; after, he click in a NEXT button, and see the fields 11 to 20; and after ..... until 991 to 1000.
Do you imagine how could i implement this?
I tried something with "Select First 10 * from CUSTOMERS", but i dont know how to continue the implementation.
Could you help me with this?
Will it be different if it was in MS SQL Server?