Every 25th record

[mdonahoe]

This is probably something very simple but I just can't think of it at
the time. I want a query to run and display every 25th record, with a
field that will show a number in consecutive order: Page 1 Part#
55554 (next row) Page 2 Part# 45689 , etc.

Hopefully that makes sense.

MDD

 

[Arvin Meyer]

I'm not sure I understand exactly, but if you have a sequential ID field,
using a Modulus of 25 will give you your result.

SELECT [ID] Mod 25 AS Expr1, [Part#]
FROM MyTable
WHERE ((([ID] Mod 25)=0));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access