Greetings,
I have design a report to determine the total # of applicants in a given fiscal year. When the user clicks on “Fiscal Year Report” the following dialog box will appear, and the user can also change the dates for a desire year.
Start Fiscal Year: 01/07/02
End Fiscal Year: 06/30/03
At the bottom I have =Sum([Jan]), =Sum([Feb]) etc. for fiscal year total. When the user changes the year, let’s say 06 – 07, since there is no data, I was trying to get the report to show nothing (blank), instead of #Error. I used IIf, Nz, IsNull etc. several ways and wasn’t successful. Can anybody tell me the correct syntax to use?
Thanks,
DD
I have design a report to determine the total # of applicants in a given fiscal year. When the user clicks on “Fiscal Year Report” the following dialog box will appear, and the user can also change the dates for a desire year.
Start Fiscal Year: 01/07/02
End Fiscal Year: 06/30/03
At the bottom I have =Sum([Jan]), =Sum([Feb]) etc. for fiscal year total. When the user changes the year, let’s say 06 – 07, since there is no data, I was trying to get the report to show nothing (blank), instead of #Error. I used IIf, Nz, IsNull etc. several ways and wasn’t successful. Can anybody tell me the correct syntax to use?
Thanks,
DD
