replace query

[Guest]

morning all

i have a table with numberical values, these values have a minus - sign
before the value, i would like to run a replace query which will remove the -
value and replace it with a space i.e. -325.25 to 325.25

any suggestions and thank you in advance

Nick

 

[Ofer Cohen]

First BackUp your data,

Use Update query with the function Abs to replace the negetive value

Update TableName Set FieldName = Abs([FieldName])

You wrote that you want to replace the minus sign with space, you can do
that only if the field type is text.

Try
Update TableName Set FieldName = Replace([FieldName],"-"," ")

 

[Guest]

Sorry but what is the function abs?

First BackUp your data,

Use Update query with the function Abs to replace the negetive value

Update TableName Set FieldName = Abs([FieldName])

You wrote that you want to replace the minus sign with space, you can do
that only if the field type is text.

Try
Update TableName Set FieldName = Replace([FieldName],"-"," ")

morning all

i have a table with numberical values, these values have a minus - sign
before the value, i would like to run a replace query which will remove the -
value and replace it with a space i.e. -325.25 to 325.25

any suggestions and thank you in advance

Nick

 

[Ofer Cohen]

From the help

"Returns a value of the same type that is pass to it specifying the absolute
value of a number"

Abs(-233) will return 233

Sorry but what is the function abs?

First BackUp your data,

Use Update query with the function Abs to replace the negetive value

Update TableName Set FieldName = Abs([FieldName])

You wrote that you want to replace the minus sign with space, you can do
that only if the field type is text.

Try
Update TableName Set FieldName = Replace([FieldName],"-"," ")

morning all

i have a table with numberical values, these values have a minus - sign
before the value, i would like to run a replace query which will

remove
the -

value and replace it with a space i.e. -325.25 to 325.25

any suggestions and thank you in advance

Nick