Convert Negative to Positive - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Convert Negative to Positive

Ramona Woitas

4 years ago

Is there an easy way to convert a negative number into a positive number in a calculated field?

Field was created in a query (Amount) and contains positive and negative numbers.

I would like the negative numbers to be converted into positive numbers, and the positive numbers remain positive.

	Scott Axton @Reply 4 years ago
Sure, just use the Absolute Value function in your query or calculated field. Amount = ABS(Amount)

	Alex Hedley @Reply 4 years ago
Glossary: Abs

	Ramona Woitas OP @Reply 4 years ago
Thanks. You guys Rock! :)

	Ronald de Boer @Reply 4 years ago
Or you could just multiple by -1

	Scott Axton @Reply 4 years ago
Ronald that would work for the negative numbers but would convert the positive to negative. So... That wouldn't be a solution in Ramona's case.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View