I have no experience with Field Calculator in ArcGIS 10.
I have a very simple calculation I would like to perform that I could do easily via pure SQL but just can't seem to get my head around it in the Field Calculator.
Basically I have a table of 5000 weeds of which there are around 10 types. I want to update one field in the table (called CLASS) to be either A, B, or C depending on another field: WEED_NAME
So, if WEED_NAME = 'Hyptis' then Class = 'A' else if WEED_NAME = 'Parkinsonia' then Class = 'B' etc
I know it is very basic, but I just can't seem to get my head around it on this long Wednesday afternoon.