Access 2007: Change the value in a table field based on the value in another field in same table

Posted on 2011-04-28
Last Modified: 2012-05-11
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?
Question by:Bevos
    LVL 39

    Expert Comment

    I think this question was answered. You can close it without assigning points.
    LVL 30

    Accepted Solution

    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')

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now