How to assign Rnd function to a specific column in a table?

[shroomyszn]

Hello



I'm using access to complete an accounting assignment and I'm having a terrible time with it. Hopefully someone can help

I have a form in which one column is an autonumber called "Student ID". I would like this autonumber to display a random number between 10000000 and 99999999.

I have used the Rnd function to create this random number generator but I have absolutely no idea how to assign it to my Student ID column?

Thank you for the time, any help would be appreciated

[CJ_London]

I presume this autonumber field is your primary key - in which case it should have no meaning other than as a unique identifier for a record. Autonumber fields cannot be changed once a value is set and it is set as soon as you create the record. Suggest leave the autonumber field alone and create another field for your student ID.

With regards assigning your function value, this cannot be done at the table level, you will either need to use an append or update query or use code in a form before update event

Edit: autonumber fields can be set to generate random numbers rather than incremental, but they will include negatives and cannot be limited to a range