I would like to build a form that allows a user to enter a value into a text

box corresponding to the interval between records that they would like to

view (i.e.  show me every 51st record in a recordset) and then press a

button that will run a query and select the records and display the records

.  I am having difficulty determining what the "where" clause would be.



Thank you.



Thomas

Have a look at



http://www.mvps.org/access/queries/qry0006.htm



for one method.



HTH,



-Roy



-----Original Message-----

From: Thomas MacKenzie [mailto:mackenzieinlb@y...]

Sent: Tuesday, July 17, 2001 1:33 PM

To: Access

Subject: [access] Selecting sample records





I would like to build a form that allows a user to enter a value into a text

box corresponding to the interval between records that they would like to

view (i.e.  show me every 51st record in a recordset) and then press a

button that will run a query and select the records and display the records

.  I am having difficulty determining what the "where" clause would be.



Thank you.



Thomas