Syntax dual if statement

Fri, 17 Jan 2014 17:05:26 GMT

Hi i am experiencing a problem with brackets in the following statement.

please advise as both statement work individually.

if(len(trim(SlutKundxOrderKund2.MasterKund))=8

and isnum(left(trim(SlutKundxOrderKund2.MasterKund),4))

and isnum(right(trim(SlutKundxOrderKund2.MasterKund),4)),

left(SlutKundxOrderKund2.MasterKund,4) & '-0000',

if(right(SlutKundxOrderKund2.MasterKund,4) = '0000'

and SlutKundxOrderKund2.Giltig_flagga = 0,

left([SlutKundxOrderKund2.Text 1],9),'Oäkta') as Slutkund

your help is greatly appreciated

Brad

Re: Syntax dual if statement

Gysbert_Wassenaar — Fri, 17 Jan 2014 17:21:34 GMT