Roster Rotation query?? BRAIN TEASER!

[Nieche]

I have a database with about 500 submitions and 16 reps Im looking for a way to do a query to assign the 16 reps to each of the 500 submitions in a variance of 5. Ie: the 16 reps are assigned the subs in a row 5 times down the list then on the fifth time it gives one extra to 4 specific reps of the 16 before continuing its way down the list. any suggestions?

 

[DougP]

Anything can be done with VBA code.
you need to create a function in a module

If I follow what you are saying
open the sub's table
Open the reps table
then open a new table where you assign the reps to a sub

loop through the subs and jump however you want using a "movenext" in a loop.


For a = 1 to rstSub.recordcount
'write something to new table
for b = 1 to 5
rstSub.movenext
next
next

this is vague
But I can help if you start it.




DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.