Percentage Complete by State on a report

[cwhite23]

Hi all,

I am currently working on a call log database that shows the percentage of people called broken down by state. Ex. AL=65%, AR=14%, etc. Is there any way of pulling this data into a report where I can show the percentages for each state on a map? I have successfully set up the map, but I don't know how to do the rest. I am trying to put the percentage within the state's borders. I have tried several optins, but haven't had much success. Any help would be appreciated.

 

[PWise]

you have to pivot your results by state and place the field with each state on that state

 

[dhookom]

Where did you "set up the map"? If this is an image in a report, I would create a table of states with x and y coordinates. You could then use code in the On Format event of a report section to position the percentage value. The x and y values should be in twips (1/1440 inch). You can then adjust these values to move the percentages as needed.

Duane
Hook'D on Access
MS Access MVP