Rand Function (Access custom web app)

Returns a pseudo-random number between 0 and 1.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Syntax

Rand ( [ Seed ])

The Rand function contains the following argument.

Argument name Description
Seed
An integer expression that gives the seed value. If Seed is not specified, a seed value is assigned at random.

Remarks

Repetitive calls of the Rand function with the same seed return the same results.