Generating random numbers

[DataDuck]

Hi... I am trying to generate a random number sequence in an already existing access file. It is my understanding that the number generator will only fill in on new records, not already existing ones. I have tried creating a new file that has a field that would generate the random number code and then append the data file thinking that the incoming data would in fact generate the numbers. I have failed at this attempt after many many tries. Any help would be appreciated.

Thanks.

 

[Remou]

You mention Access. You can use Rnd:

Int((100 * Rnd) + 1)

Will give a random number between 1 and 100.

The Access fora are:
Microsoft: Access Forms Forum: forum702
Microsoft: Access Modules (VBA Coding) Forum: forum705
Microsoft: Access Queries and JET SQL Forum: forum701
Microsoft: Access Reports Forum: forum703
Microsoft: Access Tables and Relationships Forum: forum700
Microsoft: Access Other topics Forum: forum181