When I used the data mapping wizard and mapped counts by county mp only mapped some of the data. I had done a "Group by" and "count " in Access after importing data originally in Excel. I added teh county field twice to the query design grid in order to be able to do both a group by and count after clicking the totals button on teh tool bar in teh query design view. My guess is the county data wasn't unique since some states have the same county names.
My question is: How do I run the query so I can get unique county values? If I add teh state field to the query it also has a "Group by" drop down so grouping by state wouldn't yield teh correct results either.
IT was worse when I tried to have the data mapping wizard use teh count function.