find and enter true/false data cell

mtrant

Registered User.
Local time
Yesterday, 23:23
Joined
Aug 21, 2008
Messages
15
Hi,

I was curious, I have an accesss database that we manage all of our products in. I have recently been sent a sheet that has a lot of discontinued products. I have matched those skus up to the products and was wondering if there was a way to change the value in a column based on if the cell next to it has any kind of data in it.


for example

Product Name........DISCONTINUED............DIS SKU
Fabric 1......................False...................5468
Fabirc 2......................False...................
Fabric 3......................False...................9821


So I want the "False" to change to "True" in clumn "B" because there is data in COLUMN "C". I only want the Fabric 1 and 3 columns to saw true.

Is this possible?
 
What about an update query:

UPDATE TableName
SET DISCONTINUED = True
WHERE [DIS SKU] Is Not Null
 
Thank you, huge help!
 

Users who are viewing this thread

Back
Top Bottom