Coalesce function (Access custom web app)
Returns the first expression that is not NULL from a list of arguments.
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, look into our Office Cloud Storage Partner Program.
Syntax
Coalesce (Value, [Value], …,[Value])
The Coalesce function contains the following arguments
Argument name | Description |
---|---|
Value |
An expression. |
Remarks
If all arguments are NULL, Coalesce returns NULL.
Example
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.
Coalesce([First Name],[Last Name],[Email],[Mobile Phone],[Work Phone],[Home Phone],[Company]) Is Not Null