Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Access 2003 Query

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!
0
submarinerssbn731
Asked:
submarinerssbn731
2 Solutions
 
irudykCommented:
Try something like the following:
UPDATE TableName
SET [Closed] = True
WHERE [Status]="COMPLETE" AND [Closed]=False
0
 
Guru JiCommented:
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"
0
 
submarinerssbn731Author Commented:
Great answers!!!  Thanks!!!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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