hi everybody,
my name is Antonio and I write from Italy.
It's quite long time I use Access and it's my first time i see the following message
"TOO COMPLEX QUERY" for the following:
KPI-2017: IIf([kpi-red]<0,2 And [kpi-strut-az]<0,25;([kpi-capacita-innovare]+[kpi-strut-az]+[kpi-red])/3;IIf([kpi-red]<0,2 And [kpi-strut-az]>0,25;([kpi-capacita-innovare]+[kpi-strut-az]+[kpi-red]+([kpi-strut-az]*0,8))/3;IIf([kpi-red]>0,2 And [kpi-strut-az]<0,25;([kpi-capacita-innovare]+[kpi-strut-az]+[kpi-red])/3;([kpi-capacita-innovare]+[kpi-strut-az]+[kpi-red])/3)))
Can anybody help me?
thanks