Syntax dual if statement

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Try adding a final ')' at the end so they all match up:

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