[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
>