Coalesce Function (Access 2013 custom web app)
Published: July 16, 2012
Returns the first expression that is not NULL from a list of arguments.
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