Evaluation Form

[Accesspert]

Hi, I have a form where it does an assement of the service in the call center.
The evaluation form has 3 check boxes (yea, no, n/a). There are 163 employees that need to be evaluated on their performance.
How would I go about setting this up?
What I've done so far is made a table called evaluation with all the questions in it and 163 employee IDs. Now how do i get this evaluation to work properly and do the calculations? I know how it's suppose to be weighted but I don't know how to setup the tables so that this would actually work and save the information in a table so that I can create reports after.
Thanks.

 

[Ethereal]

1) make a table with fields EmployeeName(text); EmployeeID(number);question1(checkbox);question2(checkbox) etc
2) try using the form wizard to start and then modify it in design mode

 

[Accesspert]

I already have my form done and I know how much each question weights but i can't get it to do what it's suppose to.
I have two table Evaluation and EvaluationWeight. I've designed a module that will do the evaluation but now i need a query that will take the yes/no/n/a information and put it in the evaluation table and do the calculation.

 

[pepegot1]

I created a similar Form and it places numbers 1,2,3,etc. into the fields. I edited the property dialog, but it does not accept the change. After I change it, and look at it again, it reverts to the original number. How can this be fixed?

 

[Ethereal]

I Am kind of confused as to what you need.. Can you post a Sample DB ?

 

[Accesspert]

I'm not sure if u were talking to me but here's my db. The form is called frmServiceQualityAssessment and my tables are called tblEvaluation and tblEvaluationWeight.

 

[Ethereal]

Ok, I have altered the format of your table... The fields are now yes/no fields... If you click a box it's yes.. If you click again its NO and if you never click at all it is Null or (N/A) Now you have to set all the control sources of the "yes" buttons on your form to the corresponding fields. As for your "total" box i think it would be easier to do a calculation right in that form's module rather than make another table. Just make a function that calculates the total
something like
Dim total as Integer
total = 0
total = total + IIf(Me.OpeningCall, 3,0)
total = total + IIf(Me.Empathy, 2,0)
total = total + IIf(Me.ConversionControll, 8, 0)
txtTotal = total

 

[Accesspert]

Thanks for your help, I really appreciate it. However, I need to have the checkbox yes, no and n/a, I can't just have yes. The form's design requires both yes, no and n/a. I don't quite understand how u did the tables and how it saves this information into the tables.

 

[Ethereal]

i didn't change the label on "yes" but that checkbox corresponds to three values.... True, False, and Null... As i left it there it doesn't save info to the tables, you have to set the control source of that box to the correct field in your table

 

[Accesspert]

Oh ok, but can i put the checkbox yes, no and n/a and do the same thing u did?

 

[Ethereal]

yes, just set the control source of the check to your table, but change the fields to yes/no fields

 

[Accesspert]

Ok can i make the changes and send it back to u to see if I did it right?