Update Query Changing value to negative

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use an update query to change values in a table to negative.
Any suggestions.
 
All values I need to change are different. Is there a special command or wild
card that I need to use to multiply different values by -1?
 
Create a select query that pulls the records to be updated. Run it and
review ( better yet is to backup the database first ).
Say the your field is "GardenTops", so in the design view of the query,
click on the icon that looks like two datasheets with a down arrowhead to the
right. Select Update Query.
In the Update To row put this ---
[GardenTops] * -1
If you have some that are negative now and do not want to change to a
positive number then add criteria of >0 (greater than zero),

It will multiply all seleced records by -1 and replace what is there.
 
Back
Top