D
donallen
Is there any way within Access to convert a negative number to a positive?
We are importing data that is both negative and positive but we are sending
this to a company that wants the "sign" + or - in one field and the number
in a separate field. Like this
Table 1
Number
2567.00
-428.90
Table 2
Sign Number
+ 2567.00
- 428.90
Thanks
Don
We are importing data that is both negative and positive but we are sending
this to a company that wants the "sign" + or - in one field and the number
in a separate field. Like this
Table 1
Number
2567.00
-428.90
Table 2
Sign Number
+ 2567.00
- 428.90
Thanks
Don