Multiple counties in field that need to be combined

Discussion created by richber99 on Mar 24, 2014
Latest reply on Mar 28, 2014 by jimcousins
Dear Friends:  I'm a newbie and I'm struggling through my first project!  I have a table that I'm trying to symbolize as a chloropleth based on the number of employees for a map for a couple of counties in Kansas.  I'm so close I can almost taste the map! I have joined and joined to get a table with the number of employees in one field and the counties in another but I have multiple listing for the counties.  (I used "towns" as my primary key.)  All I have to do -- I think -- is merge the records with similar counties to total the number of employees of the companies in that town.  And I'm a little stumped.  Any ideas?

Thanks Rich