Reverse True/False

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Do I have to just live with it?

A table has a field named "Inactive". That's counter-intuitive is this case.

I would like to change the field name to "Active" and update the data
accordingly. That is, make True become False and vice-versa. All my query
attempts end in frustration. It is a Y/N field...I don't need nulls.

Is there a simple technique? Can someone advise the simple way OR tell me
to just get over it?
 
hi Chris,
Do I have to just live with it?
Click to expand...
Not sure.)
Is there a simple technique? Can someone advise the simple way OR tell me
to just get over it?
Click to expand...

UPDATE [yourTable]
SET [Active] = NOT [Active]

should work.


mfG
--> stefan <--
 
Thanks for responding. I saw Jeff's and it worked.
--
Thanks for your help,
Chris


Stefan Hoffmann said:
hi Chris,
Do I have to just live with it?
Click to expand...
Not sure.)
Is there a simple technique? Can someone advise the simple way OR tell me
to just get over it?
Click to expand...

UPDATE [yourTable]
SET [Active] = NOT [Active]

should work.


mfG
--> stefan <--
Click to expand...
 
Chris said:
Do I have to just live with it?

A table has a field named "Inactive". That's counter-intuitive is this
case.

I would like to change the field name to "Active" and update the data
accordingly. That is, make True become False and vice-versa. All my query
attempts end in frustration. It is a Y/N field...I don't need nulls.

Is there a simple technique? Can someone advise the simple way OR tell me
to just get over it?
Click to expand...

Bear in mind that this method may require you to rename some items
accordingly.

Create another Boolean field and name it Active. Run an update query on the
table and update the new field to "Not ([Inactive])". Check the update and
then delete the old field.

HTH - Keith.
www.keithwilby.com
 
Back
Top