Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 9 down vote accepted

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.

share|improve this answer
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 '11 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 '11 at 14:42
It works really great! This is exactly what I needed. Thank you very much! – Muschter Nov 4 '11 at 15:41
No problem buddy =) Be sure to mark this question as "answered" whenever you get a chance. – dmahr Nov 4 '11 at 16:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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