V
Vida SF
On a dental screening form for kindergardeners, I have 3 fields (Class I
Cavities, Class II Cavities, Class III Cavities) with True/False datatype
(check box on form).
In any given record, all three fields may be False (no cavaties...) however
no more than one can be True, (when cavaties are present, are you with me?)
My question is this. How can I set up a query that tells me only the one
field name where value is "True", so I can build it into a report for each
kid?
I didn't design this database. If I had I would have made one field called
"Severity", with a combo box with Class 1-III (and none).
The tooth fairy will smile upon you if you can help me out of this little
jam. Thanks!
Cavities, Class II Cavities, Class III Cavities) with True/False datatype
(check box on form).
In any given record, all three fields may be False (no cavaties...) however
no more than one can be True, (when cavaties are present, are you with me?)
My question is this. How can I set up a query that tells me only the one
field name where value is "True", so I can build it into a report for each
kid?
I didn't design this database. If I had I would have made one field called
"Severity", with a combo box with Class 1-III (and none).
The tooth fairy will smile upon you if you can help me out of this little
jam. Thanks!