I am using Access 2002 sp 2 on a Windows 2000 sp 2 computer.
When writing a query or code and a field is text or a string, what is the difference with an if statement when asked as follows, because I get different answers with each statement, and don't understand why.
Iif([field]="", then do something
Iif([field]Is Null then do something
The field is used for a street address, and for some the is null works and for others it does not, and the ="" works. And I can't for the life of me figure out why.
Thanks to anyone for any help you can give.
When writing a query or code and a field is text or a string, what is the difference with an if statement when asked as follows, because I get different answers with each statement, and don't understand why.
Iif([field]="", then do something
Iif([field]Is Null then do something
The field is used for a street address, and for some the is null works and for others it does not, and the ="" works. And I can't for the life of me figure out why.
Thanks to anyone for any help you can give.