find and enter true/false data cell

[mtrant]

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?

 

[pbaldy]

What about an update query:

UPDATE TableName
SET DISCONTINUED = True
WHERE [DIS SKU] Is Not Null

 

[mtrant]

Thank you, huge help!