Bevos
asked on
Access 2007: Change the value in a table field based on the value in another field in same table
Hello, I have a database which I am attaching to this question. The form frmDecision tree is designed to be a series of check boxes that the user will work with and then a final decision will be generated based on the user's input. One of the great experts here helped me with this part already and I have a field called New Reviewed Item in qryDecisionTree which is coded -1 for true or 0 for false. I want the field [Reviewed Item] to be coded INC for all values -1 in [New Reviewed Item] and EXC when 0 in that same field. Could anyone please show me how to do this?
EE-example-2-.accdb
EE-example-2-.accdb
I think this question was answered. You can close it without assigning points.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.