Error Message: The expression you entered is too complex. IIF stat

N

New2Access

I am trying to create a report and I get an error message saying that "The
expression you entered is too complex" every time I try to save the formula
below in the 'Control Source' section. Is there any way I can divide this up
in the same formula? Can you please help?


=IIf([measure]='Address',[address_beginning],IIf([measure]='Customer',[customer_beginning],IIf([measure]='Mail',[mail_beginning],IIf([measure]='checks',[checks_beginning],IIf([measure]='License,[license_beginning],IIf([measure]='dates',[dates_beginning],IIf([measure]='TAX',[tax_beginning],IIf([measure]='FEE',[fee_beginning],IIf([measure]='ADDR',[addr_beginning],IIf([measure]='RSCH',[rsch_beginning],IIf([measure]='Search',[search_beginning],IIf([measure]='Job',[Job_beginning],[demographic_beginning]))))))))))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Complex Sum 2
IIf expression 3
Expression You Enter is Too Complex - Help PLEASE 7
query expression too complex 6
is this query really too complex? 2
"Query too complex" workaround 4
if a # then sum, if text leave null 2
Getting error: "The expression you entered is too complex" in quer 6

Top