IIF in query

[Blessy]

i need help with putting iif statements together in my query and I will be glad with any little help.



Expressions in a Query
IIF order< 0, AND received = 0 , "Current Year"
IIF order>0, AND received =0, "Current Year"
IIF order>0, AND received<0, "Current Year"
IIF order=0, AND received>0, "Prior Year"
IIF order is null AND received>0, "Prior Year"
IIF order=0 AND received=0, “Prior Year
IIF order>0, AND received>0, "Prior Year"
IIF order=0, AND received>0, "Prior Year"

[June7]

That might be too many IIfs for nesting, 7 might be limit. Maybe you don't need all those conditions.
IIf(order<>0 AND received<=0, "Current Year", "Prior Year")