Transpose data into one field based on another

[Joseppi]

This might be a confusing question and I'll apologize up front.

I am trying to clean up / revamp a table (tblIncidents) which is presently using several check box (Yes/No) fields.

Part of the cleanup includes changing the values from the (Yes/No) check boxes into actual values in a separate field. Specifically, I want to take all records that currently have the "CAT3" checkbox selected (YES) and populate a new field (CATEGORY) with the correct value = "(CAT 3) Malicious Code"

I want to change about 10000 records to reflect the correct CATEGORY (9 different ones) using a query or something other than going through each record and manually selecting the CATEGORY based on the current check boxes.

Any help would be greatly appreciated.

 

[pbaldy]

It sounds like you have a normalization problem. 9 checkbox fields should probably be records in a related table. That said, try an update query:

UPDATE TableName
SET Category = "Whatever"
WHERE CAT3 = True

 

[pbaldy]

Thread undeleted/closed on the theory that threads with replies should not be deleted.