• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

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
0
Bevos
Asked:
Bevos
1 Solution
 
als315Commented:
I think this question was answered. You can close it without assigning points.
0
 
hnasrCommented:
Reviewed Item: IIf(([PPopulation] And [DDesign1] And [O1Outcome1]) Or ([PPopulation] And NOT([DDesign1])) And [D2Design2] And [O2Outcome2] And [SP_YN]) Or ([PPopulation] And not([DDesign1]) And [D2Design2] And [O2Outcome2] And not([SP_YN]) And [NTotal]>=100),'INC','EXC')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now