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!
Steve EckermanSystems AdministratorAsked:
Who is Participating?
 
Guru JiConnect With a Mentor Commented:
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
 
irudykConnect With a Mentor Commented:
Try something like the following:
UPDATE TableName
SET [Closed] = True
WHERE [Status]="COMPLETE" AND [Closed]=False
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Great answers!!!  Thanks!!!
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.

All Courses

From novice to tech pro — start learning today.