Design of customer satisfaction form?

C

CW

We have a typical customer satisfaction form that has 8 questions, each of
which can be rated in 4 ways: Poor, Satisfactory, Good or Excellent, and the
customer simply checks one option for each question and returns the form.
For each job in our database we want to be able to replicate that form (or
rather, the responses) and then do a query or report to analyse these.
I can see that using an Option Group is one way of providing an on-line
form, and the design of that isn't an issue for me.
What I don't know, however, is whether I need to create some sort of table
to support this, or whether Option Groups have their own way of storing info.
And then, how do I find the entries that have been made, to collate them and
produce a query or report?
Will be very grateful if someone can suggest the best way to go about this!
Many thanks
CW
 
L

Lance

You will need to create a table to store the values in. The table should
contain a number field for each option group you put on your form. Then just
assign the controlsource for each option group to the number field in your
table, and the value will be stored there.
 
C

CW

Got it working - thanks, Lance

Lance said:
You will need to create a table to store the values in. The table should
contain a number field for each option group you put on your form. Then just
assign the controlsource for each option group to the number field in your
table, and the value will be stored there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top