M
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
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
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
fellow... Thanks
musa.biralo