Changing a numbers sign + -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to change a number that is a Negitive number, say -100 and
change it to 100 and I want to change a positive number, say 100 to -100.
This needs to be formatted as currency.

I want to show a loss in product say -10 broken widgets * $10.00 to the
customer as a charge $100.00, not ($100.00) a credit; and I want returns say,
10 returned widgets 10 widgets * $10.00 to the customer as a Credit
($100.00), not a $100.00 charge.
The expressions I am using to calculate are as follows:
ShipRecReconcile: [SumOfCustomerReturned]-[SumOfCustomerRec] and
ReconcillationAdjustment: ([ShipRecReconcile]*[UnitPrice])

How can I change a negitive number to positive and vice versa?
 
Don said:
I would like to change a number that is a Negitive number, say -100
and change it to 100 and I want to change a positive number, say 100
to -100. This needs to be formatted as currency.

I want to show a loss in product say -10 broken widgets * $10.00 to
the customer as a charge $100.00, not ($100.00) a credit; and I want
returns say, 10 returned widgets 10 widgets * $10.00 to the customer
as a Credit ($100.00), not a $100.00 charge.
The expressions I am using to calculate are as follows:
ShipRecReconcile: [SumOfCustomerReturned]-[SumOfCustomerRec] and
ReconcillationAdjustment: ([ShipRecReconcile]*[UnitPrice])

How can I change a negitive number to positive and vice versa?

You can do it like this:

ReconcillationAdjustment: -([ShipRecReconcile]*[UnitPrice])

Note the minus sign.
 
Charles and Dirk this works well!
--
Thanks,

Dennis


Dirk Goldgar said:
Don said:
I would like to change a number that is a Negitive number, say -100
and change it to 100 and I want to change a positive number, say 100
to -100. This needs to be formatted as currency.

I want to show a loss in product say -10 broken widgets * $10.00 to
the customer as a charge $100.00, not ($100.00) a credit; and I want
returns say, 10 returned widgets 10 widgets * $10.00 to the customer
as a Credit ($100.00), not a $100.00 charge.
The expressions I am using to calculate are as follows:
ShipRecReconcile: [SumOfCustomerReturned]-[SumOfCustomerRec] and
ReconcillationAdjustment: ([ShipRecReconcile]*[UnitPrice])

How can I change a negitive number to positive and vice versa?

You can do it like this:

ReconcillationAdjustment: -([ShipRecReconcile]*[UnitPrice])

Note the minus sign.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
 
How can I change a negitive number to positive and vice versa?

Put a minus sign in front of the fieldname in the expression:

- [Cost]

will be the negative of the cost (a positive number if [Cost] is
negative).

John W. Vinson[MVP]
 
Back
Top