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?
 

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

Numeric Field Overflow when appending date - how to convert it to text 1
convert a number in "12345" to 12345 16
How i can search, personnel record by grades or by name on databas 1
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
Re: Convert Number to Text and keep leading zeroes 1
How to query a field for Absolute Value in Access 2007 7
Convert numbers stored as text to numbers - Automatically - Macro 2

Back
Top