Access 2003 Query

Posted on 2012-09-10
Last Modified: 2012-09-11
I have two columns in my table one is called status the other is a check box column that is called closed.  I need a query that will  check the status column for a value of COMPLETE then update the closed column by checking the check box with a status of false.  Any ideas?  Thanks!
Question by:submarinerssbn731
    LVL 23

    Assisted Solution

    Try something like the following:
    UPDATE TableName
    SET [Closed] = True
    WHERE [Status]="COMPLETE" AND [Closed]=False
    LVL 11

    Accepted Solution

    it should be as following as per what you asking

    if your [Closed] column is bit then False = 0 and True = 1
    UPDATE TableName
    SET [Closed] = 0
    WHERE [Status]="COMPLETE"

    If you are not using Bit and just text in your Closed Column then following will do
    UPDATE TableName
    SET [Closed] = 'false'
    WHERE [Status]="COMPLETE"

    Author Closing Comment

    Great answers!!!  Thanks!!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    Sql query 12 56
    Change variables in SQL table 6 49
    What does this SQL mean? 7 30
    SQL query syntax with WHERE and '%[ABC' clause 1 19
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    794 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

    14 Experts available now in Live!

    Get 1:1 Help Now