Possible to convert a + number to a - num automatically in databas

M

MMC

Is it possible to take a specific column and specific row, in an access
database (Access 2003), and convert that positive number into a negative
number?

Please let me know if you have any information.

Also, if you need more information to answer this question, please don't
hesitate to ask.
 
M

mscertified

Yes, find the row based on its primary key and then multiply the number by -1

CurrentProject.Connection.Execute "UPDATE myTable SET myField = myField * -1
WHERE myKey = " & lngKey

-Dorian
 
M

MMC

Thanks so much for your reply. But I am not an Access expert, so would you
please explain what you mean by finding the row based on it's primary key.
How do I locate the primary key?
 

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

convert a number in "12345" to 12345 16
Re: Convert Number to Text and keep leading zeroes 1
convert a number to letter 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
How do I convert a string to a numeric value in Access? 1
How to query a field for Absolute Value in Access 2007 7
Convert Number to Time format 1
Convert week "number" to actual number to sort it in column headin 2

Top