External Data-Changing Numeric Formatting
 

Hi All,
I am importing external data via database query. There is one column of
data that is in the positive position that needs to be converted into the
negative position (entire column). i.e. 21.63 needs to read as -21.63. Can
this be done?

Thanks in advance.
Cheryl

External Data-Changing Numeric Formatting
 

Just negate the value in your SQL:

select -t.columname from tablename t

Tim


"Cheryl" wrote in message
...
Hi All,
I am importing external data via database query. There is one column of
data that is in the positive position that needs to be converted into the
negative position (entire column). i.e. 21.63 needs to read as -21.63.
Can
this be done?

Thanks in advance.
Cheryl

External Data-Changing Numeric Formatting
 

Thanks Tim. Couldn't believe the answer could be so simple!!!!
Cheryl

"Tim" wrote:

Just negate the value in your SQL:

select -t.columname from tablename t

Tim


"Cheryl" wrote in message
...
Hi All,
I am importing external data via database query. There is one column of
data that is in the positive position that needs to be converted into the
negative position (entire column). i.e. 21.63 needs to read as -21.63.
Can
this be done?

Thanks in advance.
Cheryl