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

  • Thread starter Thread starter MMC
  • Start date Start date
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.
 
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
 
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?
 
Back
Top