How do I set up IIF function to find Values that are Not Null

B

BL

Came accross a stumbling block where Function 1. seems to work and Function 2
doesn't. Any help much appreciated

1. UpdatePhone: IIf (IsNull[Bernie Test2].[Phone]),[Bernie Test1].[Phone
Number],[Bernie Test2].[Phone])

2. This does not seem to work: UpdatePhone: IIf (IsNotNull[Bernie
Test2].[Phone]),[Bernie Test1].[Phone Number],[Bernie Test2].[Phone])

Kind regards
BL
 
V

Van T. Dinh

1. There should be a opening parenthesis ( after IsNull in the first
expression. I guess it is a typing mistake in the post if the expression
works in your database.

2. IsNull() is a function and there is _no_ function named IsNotNull().
For expression 2, you can use:

Not IsNull([Bernie Test2].[Phone])

or

IsNull([Bernie Test2].[Phone]) = False
 
Top