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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OT, how do I back up Android straight to the PC? 2
How to return a value if a range (not a cell) contains a certain v 6
Calculated Controls Nz IIf 7
How do I stop outlook from automatically adding "+" to phone numbe 3
Counting records that are not null 4
how do i link up 2 sets of data into 1 set of data in excel 2
Linq to XML--Are there code examples that make Linq as easy as SQL? Or how can I convert ths simple 4
How do I count records using an iif statement? 1

Back
Top