ACC2000: Using Query to Return Every Nth Record from a Table (207651)
The information in this article applies to:
This article was previously published under Q207651 This article applies only to a Microsoft Access database (.mdb).
Advanced: Requires expert coding, interoperability, and multiuser skills.
SUMMARY
This article shows you two methods that you can use to return every Nth
record from a table. The first method is the simplest. It uses an
AutoNumber field, but this method is not always reliable. The second method
is reliable although a little more complex. It uses a dynamic counter in a query.
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbhowto KB207651 |
---|
|