Negative in the wrong place

[lakers8175]

I have a table where the "-" sign is to the right od the number. I need to move the negative over to the left of the number, so I can make it a numberic field and do calculations. I would like to do it in a query, if it can't be done, then whatever works best.


Please Help

 

[dalchri]

This query ought to do the trick:
[tt]
UPDATE YourTable
SET TextField = '-' & Left(TextField,Len(TextField)-1)
WHERE Right(TextField,1) = '-'
[/tt]

 

[lakers8175]

Thank you, it worked