Converting negative numbers stored as text to numbers

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.
 
G

Guest

What datatype did you change to - number - integer? Integers are all
positive numbers. Use Single or Double.
 
G

Guest

What datatype did you change to - number - integer? Integers are all
positive numbers. Use Single or Double.
 
Joined
May 15, 2017
Messages
1
Reaction score
0
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

Top