Append Query to Boolean Column with Criteria

Posted on 2007-10-09
Last Modified: 2008-02-01
I'm trying to create an append query to a blank table "Checklist".  
Column Checklist.NEWGRNBLT is boolean.
I'd like to append to NEWGRNBLT if (Table1.VAL14 <>0) and I'm having trouble doing this in query design.
Question by:shelbyinfotech
    LVL 18

    Expert Comment

    by:Sham Haque
    <> False
    LVL 77

    Expert Comment

    I can't quite imagine what trouble you are having.
    You just need to specify <>0 in the criteria cell for column Val14.

    Author Comment

    I guess I'm not explaining it well.

    I want to append to the column NEWGRNBELT the value of "TRUE" if VAL14 <> 0

    Accepted Solution

    Got it figured out.

    Needed to put "Expr1: True" in the 'field' section with NEWGRNBLT in the 'append to' section
    LVL 1

    Expert Comment

    Closed, 125 points refunded.
    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    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…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    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, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    761 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

    15 Experts available now in Live!

    Get 1:1 Help Now