[AccessD] how to use IIF for six different fields

Kostas Konstantinidis kost36 at otenet.gr
Mon Jun 8 07:06:54 CDT 2009


A.D. and Stuart
thank's both of you

/kostas

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, June 08, 2009 12:32 PM
Subject: Re: [AccessD] how to use IIF for six different fields


> To avoid any problems associated with returning Null if  all six fields 
> are Null, you can use:
>
> NZ(Mid((","+[F1]) & (","+[F2]) & (","+[F3]) & (","+[F4]) &
>     (","+[F5]) & (","+[F6]),2),"")
>
> -- 
> Stuart
>
> On 8 Jun 2009 at 20:58, Steve Schapel wrote:
>
>> A.D.
>
>> Just to clarify, as the expression in this example would be Null if all 6
>> fields were.  So, in addition to what you stated, we should also say that
>> the Mid() function returns Null, without error, in such a case.
>>
>> -- 
>> Regards
>> Steve
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> 





More information about the AccessD mailing list