Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Access    Excel    Word    Windows    HTML

# Rnd

## Using the Rnd Function

In this tutorial you will learn how to use the Rnd Function.

The Rnd function returns a Single containing a random number.

=Rnd[( number )]

number any valid number expression

Return Values
If number isRnd generates
Less than zero (<0)The same number every time, using number as the seed.
Greater than zero (>0)The next random number in the sequence.
Equal to zero (=0)The most recently generated number.
Not suppliedThe next random number in the sequence.

The Rnd function returns a value less than 1 but greater than or equal to zero.

The value of number determines how Rnd generates a random number:

For any given initial seed, the same number sequence is generated because each successive call to the Rnd function uses the previous number as a seed for the next number in the sequence.

Before calling Rnd, use the Randomize statement without an argument to initialize the random-number generator with a seed based on the system timer.

To produce random integers in a given range, use this formula:

`Int((upperbound - lowerbound + 1) * Rnd + lowerbound)`

Here, upperbound is the highest number in the range, and lowerbound is the lowest number in the range.

To repeat sequences of random numbers, call Rnd with a negative argument immediately before using Randomize with a numeric argument. Using Randomize with the same value for number does not repeat the previous sequence.

In this example we won't pass a value.

The result is a random number.

Query

The results using a Query would be

```	SELECT Rnd();
```

FORM

In a Form you could set the Default Value of a Textbox to

```	=Rnd()
```
VBA

In a Form add a TEXTBOX control and rename it "txtRnd", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtRnd = Rnd()
End Sub
```

Courses Tips

See this FREE Tip on Rnd.

Search

 Check out these other pages that may be of interest to you:
 12/1/2022 Load Faster 11/29/2022 Date Buttons 11/29/2022 Change Date Field 11/28/2022 Top X 11/27/2022 System Settings 11/25/2022 Application Title 11/24/2022 Full HTML Editor in Access 11/24/2022 Change Database Title 11/23/2022 Other Names 11/21/2022 Check Icon File