switch minus from right to left access

[vojinb]

Hi,
I have table with imported negative sign on right side, like
23234,45-

How to switch minus to left, to have -23234,45?

 

[Taruz]

Hi..

This can be useful..:

update tabloname set 
     fieldname = "-" & left([fieldname],len([fieldname])-1)
where right([fieldname],1)="-"

 

[vojinb]

Hi,
Thanks
but when I try it gives me error "wrong number of arguments.."

 

[stopher]

Can you copy and paste the exact SQL you have entered.

Chris

 

[vojinb]

Hi,
the sql is same as in example above:

Update bilansuspjeha set OPENING_BALANCE = "-" & left([OPENING_BALANCE],len([OPENING_BALANCE])-1)
where right([OPENING_BALANCE],1)="-"

 

[vojinb]

Hi,
stupid me, it is working )
i was missed one bracket in query, I just saw it
Thanks once again