I'm having a real big problem.
I have a listview that show data from customer table
For testing purpose I used approx 100 record.
Going to my customer, the table was filled with 2940 records.
Each record has 15 fields
When I open the ListView the process is closed and the program crashed
I think you meant 'crude'
Nice one timo, but I still think restructuring is important, and a user will not want to go through 100 pages to find a record.
However, it was just for the mechanism. You don't necessarily have to calculate '/10' as i've made, and that query was only an example; if you add WHERE is more useful. (TotRows/NumRows in fact refers only to the queryresult)