Trying to add values in option boxes.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application that I am in the process of designing and have stumbled
on a problem. The form is for evaluation. The options are outstanding,
satisfactory,unsatisfactory and not acceptable. I wanted to use an option
box and assign values to these categories of 4,3,2,1 and then sum the values
to return a total using a text box and putting the code
(=[issue1]+[issue2]+etc) in the control source field. I have tried several
different senarios but I cannot get a total to be generated. Any Ideas?
 
I have an application that I am in the process of designing and have stumbled
on a problem. The form is for evaluation. The options are outstanding,
satisfactory,unsatisfactory and not acceptable. I wanted to use an option
box and assign values to these categories of 4,3,2,1 and then sum the values
to return a total using a text box and putting the code
(=[issue1]+[issue2]+etc) in the control source field. I have tried several
different senarios but I cannot get a total to be generated. Any Ideas?
Click to expand...

I would suggest a different design. DON'T think you can store
evaluations in a Form - you can't! If you're using a Table with one
field for each issue, that's probably a bad idea too: if you have many
Issues for each Employee, and many Employees for each Issue, a better
design would be to have three tables:

Employees
EmployeeID
<biographical data>

Issues
IssueID Primary Key
Issue <Text or Memo>
<other fields about the issue as a whole>

Evaluations
EmployeeID <link to Employees>
IssueID <link to Issues>
Evaluation <Integer>

You'ld use a subform based on a query left-joining Issues to
Evaluations; include both IssueID fields so it's updateable, and use
an option group or combo box to select the Evaluation, 1 to 5. You'll
then be able to use a Totals query to sum the evaluation values.

John W. Vinson[MVP]
 
Back
Top