A new field to auto insert numbers

[asante_za]

have a large database of students. The system should create a a new field
"Assigned" to assign the students, numers to a certain maximum, say 5.
The first 5 on the list will asume 1, 2, 3, 4, 5
The next 5 will assume 6, 7, 8, 9, 10

The output of the query will look like:

Name Assigned
kkk 1
jjj 2
uuu 3
ppp 4
ttt 5
eee 1
ggg 2
fff 3
rrr 4
ttt 5

 

[Duane Hookom]

There are many examples of sql to create a rank value in a query in this
news group. You would need to add a MOD 5 to get the rotation.

One requirement is to have a field value that identifies the unique order.