Converting negative numbers stored as text to numbers

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

Guest

In one of the fields in my table the numbers are stored as text and negative
numbers have a "+" or "-" character preceeding it. When I change the field
data type from text to numbers, I lose the negative values.

Please post any suggestions.
Thank you.
 
What datatype did you change to - number - integer? Integers are all
positive numbers. Use Single or Double.
 
What datatype did you change to - number - integer? Integers are all
positive numbers. Use Single or Double.
 
Hi,

Did anyone have an answer for this problem as its causing me all sorts of problems.

In my code below, negative numbers are not being picked up by the select statement - only positive numbers are being captured.


-------------------------------------------------------
SELECT val(nz([db].[value])) as myamount,
from [db]
-------------------------------------------------------

Thanks in advance.

Kim
 
Back
Top