INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

(OP)
I am designing a questionnaire project similar to what i did last yr using InfoPath for the questionnaire, SharePoint to house the questionnaire and access to query the results. I am looking for a better design in the way we calculate the results (if possible).
Last year I had a Specification table consisting of the document id, fieldname (question answer) and the value of the question. I wrote VBA code to build a result table with totals for each country that answered the questionnaire. So I simply read the questionnaire table, took the answer they entered and computed it against the matching question in the specification table.
Is there a better way to do this. It worked, but there are a lot of smart people on this site, I am interested in a more robust way to
tabulate the results.

RE: Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

A simple totals query might work or possibly a crosstab query. It all depends on your table structures and your desired results.

Can you provide the tables, fields, and relationships? What type of totals do you want from your data?

Duane
Hook'D on Access
MS Access MVP

RE: Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

(OP)
I have a table named questionnaire_fields which contains doc_id, country, enteredBy, businessUnit followed by a field for each question. Questions that contain repeating data ie. "select all that apply"....are contained in tables that contain the doc_ID and the field (referring to that particular question). Everything is linked on Doc_ID.

RE: Looking for a better way to report on a questionnaire finding. Mapping a value to each question.

I expect if you want to make any usefull tallies of your data, you will need to normalize it with a union query. Once normalized, you can use a totals query to tally the counts of answers by country and question.

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close