G
Guest
I would like to create an If statement to change the value of a checkbox from
no to yes if the text in another field of the record meets my criteria. In
other words, if the text in the field "Employee" says "yes", then I want the
checkbox in the field "Exempt" to be checked. If the "Employee" field is
blank, I want the checkbox to be blank.
This is an easy formula in an Excel table (=IF (CELL1="yes",yes, no), but
I'm new to Access and not sure what code I should use or where I should put
it within my table. Any help?
no to yes if the text in another field of the record meets my criteria. In
other words, if the text in the field "Employee" says "yes", then I want the
checkbox in the field "Exempt" to be checked. If the "Employee" field is
blank, I want the checkbox to be blank.
This is an easy formula in an Excel table (=IF (CELL1="yes",yes, no), but
I'm new to Access and not sure what code I should use or where I should put
it within my table. Any help?