IIF in Reports

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

I need to try to use something like the following in a textbox, but I am
having problems
Can this be done this way or is there another way, this is in a group footer

=IIf(Reports!timesheets.payrate="no","=nz(Reports!timesheets.text113,0)+nz(Reports!timesheets.text114,0)+nz(Reports!timesheets.text115,0)+nz(Reports!timesheets.text116,0)+nz(Reports!timesheets.text117,0)+nz(Reports!timesheets.text118,0)+nz(Reports!timesheets.text119,0)","0")
 
You should change the names of your controls to something that is a bit more
descriptive. Also, I expect the name of the report is TimeSheets so you can
remove all the "Reports!Timesheets." since this is default.
Remove all the extra quotes.

=IIf(payrate="no",nz(text113,0)+nz(text114,0)+nz(text115,0)+nz(text116,0)+nz(text117,0)+nz(text118,0)+nz(text119,0),0)
 
That did it thanks!
Duane Hookom said:
You should change the names of your controls to something that is a bit
more descriptive. Also, I expect the name of the report is TimeSheets so
you can remove all the "Reports!Timesheets." since this is default.
Remove all the extra quotes.

=IIf(payrate="no",nz(text113,0)+nz(text114,0)+nz(text115,0)+nz(text116,0)+nz(text117,0)+nz(text118,0)+nz(text119,0),0)
Click to expand...
 
Back
Top