Update same table based on column data

[musa.biralo]

Hi there...

Sorry for these simple question...

Table AA
ColA ColB ColC
Row1 A <null>
Row2 B <null>
Row3 C Z
Row4 D Y

Now, I am trying to update the ColA based on this:

If ColC = "" then (if ColC is blank then)
ColA = ColB
Else
ColA = ColC
EndIf

I could do this in excel but not in Access .. help is poor
fellow... Thanks

musa.biralo

 

[Jeanette Cunningham]

Hi musa.biralo,
we like the simple questions as much as the hard ones.
Here is the answer in 2 simple steps.

In the query grid under ColC in the criteria row, type Is Null.
In the Update to row, type [AA].[ColB]
Run the query.

Now open the query design and remove the criteria.
In the criteria row for ColC type Is Not Null.
In the Update to row, type [AA].[ColC]
Run the query.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[musa.biralo]

Thanks that worked!
I should have known that...but now i know

Thanks again.
musa.biralo

Hi musa.biralo,
we like the simple questions as much as the hard ones.
Here is the answer in 2 simple steps.

In the query grid under ColC in the criteria row, type Is Null.
In the Update to row, type [AA].[ColB]
Run the query.

Now open the query design and remove the criteria.
In the criteria row for ColC type Is Not Null.
In the Update to row, type [AA].[ColC]
Run the query.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi there...

Sorry for these simple question...

Table AA
               ColA   ColB   ColC
Row1                    A       <null>
Row2                    B       <null>
Row3                    C         Z

Row4                     D        Y

Now, I am trying to update the ColA based on this:

If ColC = "" then    (if ColC is blank then)
 ColA = ColB
Else
  ColA = ColC
EndIf

I could do this in excel but not in Access .. help is poor
fellow... Thanks

musa.biralo