Reverse True/False

[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?

 

[Jeff Boyce]

Chris

You can do an update query that turns the current value of the field into
the Not([ThatField]), reversing the Yes/No value.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Stefan Hoffmann]

hi Chris,

Do I have to just live with it?

Not sure.)

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

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

should work.


mfG
--> stefan <--

 

[Chris]

YES! Thanks so much. Very simple.
--
Thanks for your help,
Chris

Chris

You can do an update query that turns the current value of the field into
the Not([ThatField]), reversing the Yes/No value.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Chris]

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

hi Chris,

Do I have to just live with it?

Not sure.)

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

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

should work.


mfG
--> stefan <--

 

[Keith Wilby]

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?

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