Coalesce Function (Access custom web app)

Office 2013 and later

Returns the first expression that is not NULL from a list of arguments.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Note Note

The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error:

Sorry, we’re having server problems, so we can’t add <service> right now. Please try again later.

For cloud storage for Office Online, Office for iOS, and Office for Android, you can look into our Office Cloud Storage Partner Program.

Coalesce (Value, [Value], …,[Value])

The Coalesce function contains the following arguments

Argument name

Description

Value

An expression.

If all arguments are NULL, Coalesce returns NULL.

The following expression is used as the validation rule for a table. The expression ensures that entries are made in the First Name, Last Name, Email, Mobile Phone, Work Phone, Home Phone, and Company fields before a record is committed. If any of the listed fields are left blank, the Coalesce function returns Null, which violates the validation rule.

Copy 
Coalesce([First Name],[Last Name],[Email],[Mobile Phone],[Work Phone],[Home Phone],[Company]) Is Not Null
Show: