Expression Too Complex - Passing 29 Parameters - (See Post#15 for Database File)
I trying to pass the parameters below into a VBA Case statement, but I am getting a too complex error, I have spent all day sorting this out and this is the last step, any ideas how I can get access to take this expression.
I trying to pass the parameters below into a VBA Case statement, but I am getting a too complex error, I have spent all day sorting this out and this is the last step, any ideas how I can get access to take this expression.
Code:
1ST QTR ENERGY MONTH 13-24: FirstQtrEnerMth13to24([MNTH1],[AKW11],[AKW12],
[AKW13],[AKW14],[AKW15],[AKW16],[AKW17],[AKW18],[AKW19],[AKW20],[AKW21],[AKW22],
[AKW23],[AKW24],[NAKW11],[NAKW12],[NAKW13],[NAKW14],[NAKW15],[NAKW16],[NAKW17],
[NAKW18],[NAKW19],[NAKW20],[NAKW21],[NAKW22],[NAKW23],[NAKW24])
Last edited: