reverse checkbox code

[TeeSee]

If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks

 

[Bob Quintal]

If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks

create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]

 

[TeeSee]

If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks

create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]

Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting

If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place

"Not [Customers].[Check2]" (Without the quotes.)

 

[fredg]

If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks

create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]

Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting

If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place

"Not [Customers].[Check2]" (Without the quotes.)

The query, in SQL view, should read:

Update Customers Set Customers.[Check2] = Not [Check2];

Any checked [Check2] will become unchecked.
Any unchecked [Check2] will become checked.

 

[TeeSee]

(e-mail address removed):
If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]

Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting

If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place

"Not [Customers].[Check2]" (Without the quotes.)

The query, in  SQL view, should read:

Update Customers Set Customers.[Check2] = Not [Check2];

Any checked [Check2] will become unchecked.
Any unchecked [Check2] will become checked.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -

Thanks Fred