AnsweredAssumed Answered

New Field for Calculation or Query Help Needed

Question asked by geonetadmin on Oct 14, 2011
Latest reply on Oct 14, 2011 by rfairhur24
Original User: jcknight

I am prepping a map of zoning for parcels. In the attribute table I have one field that is the "current zoning" and another that is "proposed." I want to make a third column that identifies the parcels that are propsed to be rezoning differently so that I can map them.

For example, if I have a specific parcel zoned  "Residential 1" in the current column and its zoned "Residential 2" in the "proposed" column, I'd like the third column to be calculated to return a value that identifies is as changed. I assume that whatever method would return one value when the terms are different and a different value when they terms are the same, say both are "Residential 1".

I did it before but forgot how but it return 0 and -1 which I then mapped.

Any help would be huge!

Outcomes