toby.yadon
10-07-2011, 02:37 PM
I am currently working with large datasets, running multiple queries against 12 tables, each table contains 700,000+ records. I am looking at a way to limit the number of records returned in queries to increase performance. I have been to a lot of web pages where you can look at records 1-25 then 26-50, then 51-75... Is it possible to replicate this type of behaviour utilizing an access form or query? I have been taking random stabs at this and can not figure out how to return recordsets that are extracted from a long list but just a subset in the middle and a specified number of records long. Any chance a guru can point me in the right direction? Thank you for you patience and insight.