Grouping A List

[Guest]

I have a list of 35 items that need to be divided into five groups of seven.
Is there some way in a query such as the Top property to return items 15 to
21 from the list? The list is dynamic so some sort of criteria is not
feasible; it needs to be done by the position in the list.

Thanks!

 

[Arvin Meyer [MVP]]

Make sure that your list has a column numbered 0 through 34 then ... Add a
column to your table and use a query like below to update it:

SELECT [MyField] Mod 7+1 AS Expr1
FROM MyTable;

Your new column will contain repeated sets of 1 through 7
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access