I have a question with ArcGIS 9.2. In an attribute table the column [name] includes the name of every place in this layer. Next to that (in columns [numbers]) there should be recorded how often a place of this name is in the map.

How can I calculate this values with VBA in the field calculator?

1 Answer 1


I don't know how to do this with Field Calculator, but I do know a workaround.

Run Summary Statistics in ArcToolbox with COUNT on the [name] field. This will create another table where each unique [name] entry will have next to it the number of times it appears in the original layer. Then Join this table back to your original layer, with the [name] field as the link.

  • Thank you for the answer, but I can just choose between SUM, MEAN, MIN, MAX, RANGE, STD, FIRST and LAST. Is it possible that the COUNT option is not included in ArcGIS 9.2 and just in later varsions?
    – Muschter
    Nov 4, 2011 at 13:42
  • You're right, COUNT was not an option in 9.2. Fortunately, you do have access to the Frequency tool, which basically does the same thing.
    – dmahr
    Nov 4, 2011 at 14:42
  • It works really great! This is exactly what I needed. Thank you very much!
    – Muschter
    Nov 4, 2011 at 15:41
  • No problem buddy =) Be sure to mark this question as "answered" whenever you get a chance.
    – dmahr
    Nov 4, 2011 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.