divide value by a constant and populate same field

[ridgeview80]

Hi Folks,

Newbie... I am trying to divide a field [StandArea] (the values are currently in m2) by 10000 to get hectares. I want the result in the same field.

Thanks

[pbaldy]

If you want to actually change the data, an update query:

UPDATE TableName SET StandArea = StandArea/10000

You might want to add the Round() function.

[ridgeview80]

not clear on the directions. I am using 2007; below is pic of what I have done. I get a warning saying 0 records will be updated.



thanks again

[pbaldy]

What you have in the criteria should be in the Update To section. Or you can switch to SQL view, which is what I posted.

[ridgeview80]

thanks very much... that did it.

[pbaldy]

Happy to help.