Hello all,
I need some help generating a sum of 2 fields, where at least one field is in
blank. I've attached a very small database that shows what I'm trying to do. I
have 8 rows, and 4 columns. ID, A, B, SUM.
SUM = A + B.
However, when A is blank or B is blank, I'm getting a blank value for SUM. I
would like to recode "blank As" and "blank Bs" to zero, so that I can get
always get a value for SUM. I have 1,000 rows, so I don't want to enter this
data again.
Here is my code:
Private Sub B_LostFocus()
SUM = A + B
End Sub
Does anyone know how to recode A and B to make sure that I am getting a SUM for
every row?
Thanks,
Pablo
[Non-text portions of this message have been removed]
