Trying to divide two fields in a report!

[scholarthewise23]

How do I go about doing this? Do I use a label? Is this is the expression I use? = 1-([FieldA]/[Field])

 

[jrbarnett]

If you want to divide one field by another, assuming that they are both numeric, the syntax is:

=Field1/Field2

Of course, if field2 is 0, then it will crash with a division by zero error, so a better way is:

=Iif(Field2=0,"Div by 0 Error",Field1/Field2)

which just displays an error message rather than crashing.

John

 

[scholarthewise23]

Where do I put this syntax to make this happen in a report? Thanks for your reply!

 

[jrbarnett]

Put a textbox on the report, and set its controlsource property to the expression.
You don't have to have the Field1 and field2 shown on the report, but they must be in the underlying data set.

John

 

[scholarthewise23]

Thank you so much it worked!