Random Numbers

[Hillary]

I have a make-table query which lists parts we need to Cycle Count. I want to add a formula to the query or a field to the table to generate Random Numbers. Perferably, a formula to the query.

I added a field AutoNumber to the table and set the NewValue to Random but it returns the numbers in numerical order just as an AutoNumber does. Since this is coming from a make-table query I think the problem is that the data already exists on the table.

I looked in the help file and tried using Rand() and RandBetween(1,100000) but both returned an error when I tried to view the query, "Undefined function 'Rand' in expression". The help file also suggested to make sure I have msowcf.dll installed which I do.

Any help on creating Random Numbers is appriciated. Please keep in mind that I don't know VB:-(

Hillary

 

[Rick39]

I think the function you're looking for is Rnd()....I think Rand is for Excel