Random Number for Default Value

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using total number of records for random number 2
Generating a Random Number 4
Random numbering of records used for sorting 3
Random Sample 1
Random Function for Selecting Records 3
why does Random: Rnd() not work for random sort? 2
ntdll.dll failure after vba Int (random num) 4
fill field with random numbers 2

Top