I’m completing a report. I’ve inserted a calculated field in the report.
I'm using Access 2010
Here is an example:
=([AccessTotalsOpen]-[AccessTotalsClose])/[AccessTotalsOpen]
I get the correct answer but cannot find a way to Display/FORMAT a negative number with any of the options that I have available to me?.
Does anyone have a method to format a calculated field in a report?.
I tried this example but could not get it to work. =Format( FIELD ), “ 0; (0)”;
Much appreciate any recommendations that you have.
Kind Regards,
Michael