Changing Negative Sign from Back to Front

  • Thread starter Thread starter dipin.puri
  • Start date Start date
D

dipin.puri

I have a large set of data, most of it being numerical. In one column
however, the data imported was imported with negative values having
the negative placed at the end of the number. (ie 2314-, 543-) as
opposed to (-2314 or -543). Does anyone have a quickfix for this
problem?
 
Backup your database. Do update like this --
"-" & Left([YourField],InStr([YourField],"-")-1)
 
You must log in or register to reply here.

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

Similar Threads

Negative Number - Brackets instead of negative signs 3
Switching negative signs from back to front 4
What are the disadvantages of using the Front-end and Back-end Da. 3
Change values to negative amounts? 3
Negative Numbers 8
Import of iregular negative numbers - i.e. negatives shown as "200 2
Importing *.txt file containing negative numbers 4
Report Ignoring negative numbers 7

Back
Top