Random Number for Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want 1 field in a record to be a random number, to be used later in a
"random" sort instead of an alpha sort.

Can I set the default value of a number field to be =rnd()?

If not, how can I put a random number in the field?
 
You can set an autonumber field to be random.
From the Access Help File:
Random AutoNumbers will generate a random number that is unique to each
record within the table.
Hope this helps.
Melinda
 
Back
Top