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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert number field with year value to date field 1
converting positive number to negative 2
Working with negative numbers. 3
Import of iregular negative numbers - i.e. negatives shown as "200 2
Calculation in reports - negative number 3
Convert #s To Negative 6
Change values to negative amounts? 3
Sort numbers stored as texts as numbers 3

Back
Top