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?
 
Top