Forcing absolute values in a report

[Mcgrco]

i need to force absolute vales on the detail part of a report. That is how its displayed on the summary table. The report is based on a query which reverse the signs of one of the two lines in the summary table. This done so that the sum opn the report footer will actually be the net ie first line minus the second line.
I dont want to have to write a function for each of the fields on the .

Can anyone help

 

[Mcgrco]

Thanks but I still cant get it to work.

In the Control source of one of the fields on the report I have chaged its value from
Demand to =Abs([Demand]). This produces an #error on the report.

Any suggestions

 

[Rich]

Try deleting the original control and creating a new one.

 

[Mcgrco]

Thank you.

That worked a treat.