calculations

Hi!

I have a main db that houses student records and a relational db that houses assessment scores. I import all the 2nd graders names & id to the layout for a particular assessment. The assessment results are in a value list with 5 text choices. I need to then count all the first choice and turn into a percentage, then the 2nd, and so on.

I tried to have two fields for the "performance" results "performance" & "performance#" and then nest if statements

If(performance, "Achieved the Standard","1")

But I don't think I was getting it right somehow.

(I have this calculation if I separate the one field into 5 fields -- but the calculation is only correct in browse mode and different in view mode {this is one problem!})

The other problem I am having is using the same layout from one year to another with a different set of students without losing my calculations that have already been entered.

This is what happens when a spinner and weaver (that's spinning wool from sheep) takes to the computer. Maybe I have wool stuffed between my ears instead of brains!!!