title: IF AND OR Formula in Access
body: <p>I'm unable to use the below formula in Simple Query is MS Access while the same can be used in MS Excel and i'm getting a syntax error in which i'm unable to figure out the error.</p>
  
  <p>SUSPENSION DATE: IIF ( OR ( LEFT ( [CUSTOMER_SEGMENT] , 2) = "IP", LEFT ( [CUSTOMER_SEGMENT] , 2 ) = "IT", LEFT ( [CUSTOMER_SEGMENT] , 2)="ID"), [BILLDATE] + 55 , IIF ( Or ( LEFT ( [CUSTOMER_SEGMENT] , 2)="IG", LEFT ( [CUSTOMER_SEGMENT] , 2)="IS"), [BILLDATE] + 55 , IIF ( And ( OR ( [BARRING_SERVICE] = "A" , [BARRING_SERVICE] = "B" ), [AGE_ON_NETWORK] > = 12 ), [BILLDATE] + 55 , IIF ( AND ( OR (  [BARRING_SERVICE] = "C" , [BARRING_SERVICE] ="D" ), [AGE_ON_NETWORK] > = 12 ), [BILLDATE] + 40 , IIF ( AND ( [AGE_ON_NETWORK] > = 5, [AGE_ON_NETWORK] &lt; = 11 ) , [BILLDATE] + 34 , [BILLDATE] + 29 )))))</p>