Random number generators with no repeats

[CJ508]

I currently have 6 fields in my table that each generate a random number between 1-26 when a new record is created. The issue is that some of these numbers are duplicated whereas I need them all to be unique. Is there a simple way around this?



I have the following code in each of the 'Default Value' field properties.

(24-1)*Rnd()+1

Thanks in advance for any help offered!

CJ

[RuralGuy]

Are you using the Randomize() function?

[CJ508]

I'm using the Rnd() function in each Default Value property of each of my 6 fields, as follows:

(24-1)*Rnd()+1

Problem is I get repetitions and I need them all to be different

[RuralGuy]

Even random numbers will duplicate rendomly. If you are doing this in the field definition of the table, you are asking too much from the table. Keeping it unique will have to be your responsibility and better accomplished in a form.

[CJ508]

I understand that I am asking too much of the table, so do you know of a way I can get round this? Thanks for your responses so far

[RuralGuy]

I'm sorry but I do not.