Calculating percentages in access for survey information

[Nathalie]

Hello,

I am creating reports from the results of an employee survey given on
a 5pt scale. For my report I need to show the percentage of employee
who answered >=3 out of the total of the specific grouping based on
the line of business the respondant is from.

To show the percentage for each question, I can only think to make a
cross tab query for each question (35 in total) to get the total count
and count per question and then export the file to excel to calculate
the percentages. Does anyone know of a faster/more efficient way to
handle this?

Thank you,
Nathalie

 

[Duane Hookom]

It would help if we could see your table structure. You might want to look
at a demo download "At Your Survey" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane