Value Lists in Calculations

[littleitaly5588]

I have a training database that lists individual classes (fields) as a checkbox. When the student completes all of the training courses designated and all of the checkboxes have been checked, they are "Qualified" and a calculation field is set as "Qualified". I've been trying to change the calculation field to work with a Value List instead of individual fields, but have not been successful. Here is a shortened version (there are too many fields to list) of the present calculation:

If(

gt_electrical safety = "yes" and

gt_fire prevention = "yes" and

gt_fire extinguishers = "yes" and

gt_office safety = "yes" and

gt_first aid = "yes" and ,"QUALIFIED",""

Is there anyway of getting the same result using a Value List?

Thanks,

[mr_vodka]

Try this.

field Classes shown as a checkbox with a value list of all your classes.

Then your results Calc field could be:

Let ( [ a=ValueCount ( ValueListItems ( "FileName" ; "ClassList" )); b= ValueCount ( Classes ) ]; If ( a= b; "Classes Completed"; b & " classes done")

)

However, you might want to also have your list of classes in a seperate table, and generate your value list from that table.

Edited September 20, 2005 by Guest

[littleitaly5588]

Thank you! I'll try that.