A
Alisheba
I built the following expression in a query:
61+ Last Month: First(IIf([61+DEC1] Is Not Null,[61+DEC1],IIf([61+NOV] Is
Not Null,[61+NOV],IIf([61+OCT] Is Not Null,[61+OCT],IIf([61+SEPT] Is Not
Null,[61+SEPT],IIf([61+AUG] Is Not Null,[61+AUG],IIf([61+JULY] Is Not
Null,[61+JULY],IIf([61+JUNE] Is Not Null,[61+JUNE],IIf([61+MAY] Is Not
Null,[61+MAY],IIf([61+APRIL] Is Not Null,[61+APRIL],IIf([61+MARCH] Is Not
Null,[61+MARCH],IIf([61+FEB] Is Not Null,[61+FEB],IIf([61+JAN] Is Not
Null,[61+JAN])))))))))))))
Under criteria I'm specifying >5000
I keep getting "Expression to complex in query expression" when I run
query. The query works once I remove the criteria.
Any help would be greatly appreciated.
Thank You
61+ Last Month: First(IIf([61+DEC1] Is Not Null,[61+DEC1],IIf([61+NOV] Is
Not Null,[61+NOV],IIf([61+OCT] Is Not Null,[61+OCT],IIf([61+SEPT] Is Not
Null,[61+SEPT],IIf([61+AUG] Is Not Null,[61+AUG],IIf([61+JULY] Is Not
Null,[61+JULY],IIf([61+JUNE] Is Not Null,[61+JUNE],IIf([61+MAY] Is Not
Null,[61+MAY],IIf([61+APRIL] Is Not Null,[61+APRIL],IIf([61+MARCH] Is Not
Null,[61+MARCH],IIf([61+FEB] Is Not Null,[61+FEB],IIf([61+JAN] Is Not
Null,[61+JAN])))))))))))))
Under criteria I'm specifying >5000
I keep getting "Expression to complex in query expression" when I run
query. The query works once I remove the criteria.
Any help would be greatly appreciated.
Thank You