Hi, I'm working on a db to track results of a quarterly reading test given to students. For each student's record I have 4 layouts, one for each test, and a summary screen.

On the test layouts, I included a text field in the form of a checkbox, which I have called "At Risk?" and it uses the set of values "YES". I didn't include no, because I figured an unchecked box would be fine to signify 'no'.

On my summary layout, I have a calculated field which is supposed to case whether the value of "At Risk?" is "YES" or not and display the word "Yes" or else display "No".

Problem is: if I check a kid off, 'yes' the calc. works fine.

if I check them off 'yes' and they subsequently improve and I uncheck them to indicate that they aren't at risk anymore, the calc works fine.

if the student never was at risk, so I never check off the box, the calc doesn't work. It displays nothing, until I check and then uncheck.

What's this about?

My calc is:

Case(At Risk Reader? = "yes", "YES", "NO")

I also tried:

Case(At Risk Reader? = "yes", "YES",At Risk Reader?="","NO", "NO")

I guess I could include the values 'yes' & 'no' for the check box, then it wouldn't be an issue, but it's just a matter of being stubborn now.

Anyhow,

Thanks for your help with this, and with previous questions too,

Paul.

In the definition for your calculation field uncheck the box "Do not evaluate if all referenced fields are empty".

-bd

Thanks!

Slick as a whistle now.

Paul