Hi all,
Looking for some help with a calculated field in a form for a school assessment database, apologies for being a total noob.
This is what I'm aiming for:
I created a simple formula in the Control Source property of [ACL - Met] that examines each of the ACL1-9 fields, and adds the total together. If that number is greater than 5, it changes the value in [ACL-Met] to True.
=IIf(Abs(([ACL1]+[ACL2]+[ACL3]+[ACL4]+[ACL5]+[ACL6]+[ACL7]+[ACL8]+[ACL9]))>5,[ACL - Met]=Yes,[ACL - Met]=No)
WHen using this, the displayed value in [ACL - Met] updates accordingly, but I cannot get the data which is calculated to save back to the table, overwriting whatever is currently there.
Can anyone help, please?
Looking for some help with a calculated field in a form for a school assessment database, apologies for being a total noob.
This is what I'm aiming for:
- The table is a series of Yes/No tickbox fields for 9 different skills that can be met - [ACL1]..[ACL9]
- The tenth field is another Yes/No that stores whether at least half of the preceding group of skills has been met - ]ACL - Met]
I created a simple formula in the Control Source property of [ACL - Met] that examines each of the ACL1-9 fields, and adds the total together. If that number is greater than 5, it changes the value in [ACL-Met] to True.
=IIf(Abs(([ACL1]+[ACL2]+[ACL3]+[ACL4]+[ACL5]+[ACL6]+[ACL7]+[ACL8]+[ACL9]))>5,[ACL - Met]=Yes,[ACL - Met]=No)
WHen using this, the displayed value in [ACL - Met] updates accordingly, but I cannot get the data which is calculated to save back to the table, overwriting whatever is currently there.
Can anyone help, please?