Negative Numbers Displaying Positive (1 Viewer)
- Thread starter derekben
- Start date
I am making a financial statement. We need the expenses to hold a negative value and show up on the report as a positive number. Using the Absolute value function changes the number to a positive number without holding its negative value. Thanks
We are running the report through a query so we can not change the fields on the report. When the absolute value is added to the query, it changes all the negatives to positives but does not keep the negative value.
- Local time
- Today, 11:51
- Joined
- Aug 30, 2003
- Messages
- 36,123
My suggestion was to use the Abs() function on the report, since it's the display you're wanting to change. I suppose you could add a field to the query. In design view:
ValueForDisplay: Abs(FieldName)
and use that for display.
ValueForDisplay: Abs(FieldName)
and use that for display.
