Check box values

[Wildy71]

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.

[LiveOak]

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

-bd

[Wildy71]

Thanks!

Slick as a whistle now.

Paul