Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. akascorpious

    How do you update a number to negative in a query?

    Thanks Leslie, I had tried that before but it still wasn't working. After looking at the table again, i had jargon in that field so that would explain why it would update "0" records. I guess i updated that field before in getting this to work and didn't clean it out. My query is working...
  2. akascorpious

    How do you update a number to negative in a query?

    Thanks John! That did the trick to convert to negative numbers, but its converting all of records in this table. I have the update query on 2 tables, and i need to limit the numbers that should be negative based on a criteria from one of those tables. So my amount field in my detail table...
  3. akascorpious

    How do you update a number to negative in a query?

    Running Access 2002, doing an update query and need to update a particular field in a table to a negative amount based on another criteria. Seemed easy enough but i can't seem to do it with the query builder: "-[Detail]![Amount]"

Part and Inventory Search

Back
Top