Using a Query to give me the 160th and 320th etc.

T

TheNovice

I need to create a Query that only shows me the 160th record, 320, 480 etc.
Can anyone tell me how this can be done?
 
J

Jeff Boyce

If your records are numbered (i.e., if they include a sequence number
field), you could try using the Mod() function to take every 160th record.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top