THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Environ() Function

❮ MS Access Functions

Example

Return the value of an operating system environment variable:

SELECT Environ(1);

Definition and Usage

The Environ() function returns the value of an operating system environment variable.

Syntax

Environ(num_position)

OR:

Environ(var_name)

Parameter Values

Parameter Description
num_position An integer value that represents the numeric position of the environment variable in the table
var_name A string value that represents the name of the environment variable

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions