I am getting an Enter Parameter Value prompt when I run a report after I have put the following in the control source property of a text box:
=IIf([JanElecVol]=0,0,(IIf(Actg_FPG_Reg_Report!Desig_Num=180,Actg_FPG_Reg_Report!Jan,0)*-1)/[JanElecVol])
The Enter Parameter Value prompt is asking me to enter a value for Actg_FPG_Reg_Report. This Report is the field list for the report and Desig_Num and Jan is in the field list. What am I doing wrong? I have tried puting [] brackets and that did not help. Any help is appreciated.
=IIf([JanElecVol]=0,0,(IIf(Actg_FPG_Reg_Report!Desig_Num=180,Actg_FPG_Reg_Report!Jan,0)*-1)/[JanElecVol])
The Enter Parameter Value prompt is asking me to enter a value for Actg_FPG_Reg_Report. This Report is the field list for the report and Desig_Num and Jan is in the field list. What am I doing wrong? I have tried puting [] brackets and that did not help. Any help is appreciated.
