Got a OnClick event that will give a random number ranging between 1 and 12. On each new record a new random number is created, but on a recordset of 12 records there should be an even divided numbercollection (1 to 12)
So I create the first record and I assign a random number to it. Let's say 1. Now the second day I create the second record and assign a new random number, this time ranging from 2 to 12 since 1 is already assigned. etc. etc.
After 12 records this process should start over again. With new random numbers ranging from 1 to 12.
I know this can be done using an array, a counter for the records and the rnd function.
Unfortunatly I'm not a real codemaster and can't get it to work. Is anybody out there who could help me with the probably "banging my head against the wall right now" answer....
So I create the first record and I assign a random number to it. Let's say 1. Now the second day I create the second record and assign a new random number, this time ranging from 2 to 12 since 1 is already assigned. etc. etc.
After 12 records this process should start over again. With new random numbers ranging from 1 to 12.
I know this can be done using an array, a counter for the records and the rnd function.
Unfortunatly I'm not a real codemaster and can't get it to work. Is anybody out there who could help me with the probably "banging my head against the wall right now" answer....