Survey Results into Graph w/ percentages

[candaceb]

I have inputed the results from a survey into access, and I would like to show the results in a graph. All the answers are in text and i cannot figure out how to make the graph show the results in percentages based on a whole. Can someone please help?!?

 

[traingamer]

start with something like this

SELECT t1.txtResults, Count(t1.ID) AS CountOfID
FROM tblSurvey t1
WHERE whatevercriteria
GROUP BY t1.txtResults;

Now you have numbers...

txtResults CountofId
don't care  9
hated it    4
love it     3

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[dhookom]

There is a sample of an Access survey at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

One of the reports has pie charts with percentages.

Next time you should provide some information about your table structure. How do we know the best method to get you some place if we don't know where you are starting from?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]