does any one know of any reference guides to show all available field calculator functions and the correct sytax for each?

emailed tech support and they showed me this: http://resources.arcgis.com/content/kbase?fa=articleShow&d=29627

though can't seem to find what i'm looking for.

one problem i was having was working out the maximum value from two colums

ID | DEPTH_1 | DEPTH_2 | MAX_DEPTH

...

...

...

in the end i ended up converting my shp to tab and doing it in MapInfo updating the "MAX_DEPTH" field using "maximum(DEPTH_1,DEPTH_2)"

i am positive that this function exists in Arc i just don't seem to be able to find it, i've tried a fair few combinations of "max" "maximum" "()" "[]" and can't seem to find a statement that works in arc any ideas?

emailed tech support and they showed me this: http://resources.arcgis.com/content/kbase?fa=articleShow&d=29627

though can't seem to find what i'm looking for.

one problem i was having was working out the maximum value from two colums

ID | DEPTH_1 | DEPTH_2 | MAX_DEPTH

...

...

...

in the end i ended up converting my shp to tab and doing it in MapInfo updating the "MAX_DEPTH" field using "maximum(DEPTH_1,DEPTH_2)"

i am positive that this function exists in Arc i just don't seem to be able to find it, i've tried a fair few combinations of "max" "maximum" "()" "[]" and can't seem to find a statement that works in arc any ideas?

The Field Calculator supports both VBScript and Python in ArcGIS 10. For a complete list of functions for these supported scripting languages you can visit these websites:

http://msdn.microsoft.com/en-us/library/3ca8tfek(VS.85).aspx

http://docs.python.org/library/string.html

http://docs.python.org/library/numeric.html

http://docs.python.org/library/datetime.html

VBA support is now deprecated from the Field Calculator in ArcGIS 10.

Thanks,

Kent M.

esri