[AccessD] how to use IIF for six different fields

    You are most welcome Kostas!

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Kostas Konstantinidis 
  To: Access Developers discussion and problem solving 
  Sent: Monday, June 08, 2009 17:36
  Subject: Re: [AccessD] how to use IIF for six different fields


  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