By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

replace one value with another in query result

P: 10
I have inherited an MS Access 2003 database which is currently using multiple Yes/No fields to track specific categories of incidents. For example, the table currently has 9 separate category fields called Cat 1, Cat 2, Cat 3, .... Cat 9 that are Yes/No fields.

I want to replace these Yes/No fields with a more descriptive single field in order to more effectively manage the database.

For example, if a record currently has the CAT 1 field set to yes, I want to the new "Category" field to populate with "CAT 1 - Unauthorized Access". If the record has Cat 3 set to Yes, I want the "Category field to populate with "CAT 3 - Malware" etc.

Any assistance would be appreciated.
Jun 2 '15 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
--- Sorry...I thought this was a SQL Server question...The following answer is what I would suggest if the back-end is MSSQL ---

Create a new columns for your need so you don't disturb other processes that access the existing columns then just do a simple update statement. Once you are sure that no one is accessing the existing columns you may rename the existing columns into something else and rename the new ones. You might need to change your existing SP, front-end, functions, etc as needed.

Or...you can just create a non-persistent calculated columns that directly use these existing columns to return whatever value you need. Not much storage required, no update needed, you keep all existing process and you can refer to the new columns for your new processes.

Good Luck!!!


~~ CK
Jun 2 '15 #2

Rabbit
Expert Mod 10K+
P: 12,430
Your thread has been moved to the Access forum.

And what happens if multiple columns are set to yes?
Jun 2 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.