sircular effect

[Karen]

I have to use number 1 -14 in a Column . When reaching 14, numbering must
start at 1 again. Can you please help me with this?

 

[Duane Hookom]

You can use a variation of a ranking column with Mod to get this type of
numbering. Here is a query from the Northwind MDB where orders are numbered
1-5. You should be able to convert this for use in your application. If you
can't, come back with significant table and field names as well as what
field/expression determines the order.

SELECT (Select Count(*) FROM Orders O WHERE O.OrderID<Orders.OrderID) Mod
5+1 AS ColumnID, Orders.*
FROM Orders
ORDER BY Orders.OrderID;