Text Box Formula in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create a default value for a calculation in a text box. For
example in our database a percentage is derived by dividing two different
numbers, but if one of the values is zero then a error pops up saying "#Num!".

Is there a way to make this default to zero? If so, how would I do that?
 
Nick

Modify the formula/calculation to include handling the Div/0 and other error
conditions.

You could use the IIF() statement in your source, something like:
=IIF(...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top