Tally Survey Results

[Jeremy Rooks]

I have a database setup with 3 tables: workshop info, workshop requests, and survey. I have a view setup for each table. Under the Workshop Info i have a tab setup for "survey results" The survey has 10 questions and you can pick 'Strongly Agree', 'Agree', 'Disagree', or 'Strongly Disagree'.

What I would like to do is be able to click a button which would perform a script that would do the following.

Get the 'Workshop Title' from the currently displayed 'Workshop Info' record

Perform a find on the 'Survey' table where 'Survey::Workshop Title' = 'Workshop Info::Workshop Title'

Goto the first record in the find

Get the answer to Question 1 and if it is say 'Strongly Agree', it would take the value of the 'Workshop Info' record and add '1' to a field named 'Q1 Result SA'

Goto the next question and do the same.

Goto the next record and start back at question 1.

Once the script tallies all of the current results, i would like for it to return the original 'Workshop Info' Screen.

My problem is that I am unsure how to get the current records 'Workshop Title' and give it a value like 'x' which I can then perform a find with the 'Survey' table. If there is a way to make it perform a find without giving it a value, I am unaware of it.

My second problem is taking the 'Q1 Result SA' value and adding it to the current question if it is also a 'Strongly Agree' response.

If someone can point me in a direction or recommend a good book, I would be very thankful.

Please let me know if there is somewhere else I should be posting to.

[Ender]

You should do a search for "survey" or somthing similar. There have been a couple recent threads about summarizing surveys. The approach you're taking may be overly complex.