IIF Is Null AND

[bthomas]

Hi! I am trying to figure out how to write a formula in a query where it searches two fields in an IIF statement.

I tried...

Current and Future Territory?: IIF([Remove Account From] Is Null And IIf([Effective Billing Month/Year (Oct FY11 = 1/2011)]<=Forms![TerrMgmt-Form-ParameterForm]!cbocurrentbilling,"Y",IIf([correction?]=True,"Y","")))

I am getting an error that states I have the wrong number of arguments

And then I tried...

Current and Future Territory?: IIF (IsNull([Remove Account From]  And IIf([Effective Billing Month/Year (Oct FY11 = 1/2011)]<=Forms![TerrMgmt-Form-ParameterForm]!cbocurrentbilling,"Y",IIf([correction?]=True,"Y","")))

I am getting an error that states I have the wrong number of parentheses.

What am I doing wrong? Thanks so much!

 

[james_lankford]

maybe

Current and Future Territory?: 
IIF 
(
  [Remove Account From] is null 
  And 
  [Effective Billing Month/Year (Oct FY11 = 1/2011)] <= Forms![TerrMgmt-Form-ParameterForm]!cbocurrentbilling,
  "Y",  ' -- if the two statements above are true
  IIf   ' -- if one or both of the 2 statements above are false
  (
    [correction?] = True,
    "Y",
    ""
  )
)

 

[bthomas]

Perfect!!! Thank you so much!