How to change a negative total (count or sum) to a positive one in a report

[KNap]

Hi


I have a report which is counting and totalling numbers, but in the numbers show as negatives - I need them to show as positives.

I managed to change the total in one counting field to positive but I've forgotten how - or where I put the code....

Can anyone help please?

Thanks

[orange]

The Abs() function should work.
see http://www.techonthenet.com/access/f...umeric/abs.php

[KNap]

Thank you - but I'm new to this - where would I put this Abs() function and what should it look like?

[orange]

What is the significance of the negative numbers?
What is the impact if you were to change them all to Positives?
Without knowing the context of your situation, it is difficult to give focused info.

[KNap]

There would be no impact on anything else, the report is to basically count things - and therefore a negative is inappropriate.

Thanks

[June7]

Why would counting result in negative?

Look in the report RecordSource property. Is it table, query, or SQL statement? If one of the latter two open in design view and see if you can find the expression that worked. Otherwise, look at the ControlSource property of the textbox that has the corrected value. Is there an expression?

[KNap]

it's counting the number of clients that use a particular service in a month for example.

I seriously cannot find where/how I changed the first number from negative to positive. It's really just to make the report look nice and to stop people asking why it's a negative number.

[June7]

Still doesn't explain why the value is negative to begin with. Expression using Count function will result in positive, expression with Sum function could be negative. However, use Abs() function to return positive whether or not negative. In query or textbox:

Abs([fieldname])

or

Abs(some expression)

If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

I agree with June7 -- Why is a count negative? I think you should investigate/step through code/ debug.print etc to find the root of the problem.

Recommend you post your db as June7 suggested.