Selecting every Nth record - Access Database

[dutton]

I need to vreate a query within Access that would allow me to display every Nth record from a table beginning with a vertain record.

In detail, starting with record ID 22, I want to be able to select ever 21st record after that.

Any guidance would be greatly appreciated.

[trib4lmaniac]

If you records are numbered sequentially then you could use the following query:

SELECT *
FROM TABLE
WHERE ID - 22 MOD 21 = 0;

[dutton]

Thanks, but but when I plug WHERE ID - 22 MOD 21 = 0 into the Criteria box within Access I get an "Data type in criteria expression" error.

I do have an ID field which is sequential (autonumber)

[bge]

Thanks, but but when I plug WHERE ID - 22 MOD 21 = 0 into the Criteria box within Access I get an "Data type in criteria expression" error.

I do have an ID field which is sequential (autonumber)

Access may be getting a little confused. I would try bracketing, i.e.:

WHERE (([ID] - 22) MOD 21) = 0

I don't have Access on my current machine but did try it in MySQL. Without brackets, it didn't error out but it didn't return any rows either. With the brackets, it worked.

Barb