yballan
asked on
Formula in Access column
Dear Experts,
I have been an Access user for many years, but I never came across this needs.
As in Excel, if you have a formula that refers to 2 previous column ( ie. C2 = A2+B2), by filling in A2 and B2, you automatically get a value in C2. Is there a such function in Access?
It seems like it should exist, except I never came across it.
Please advise. Thank you.
I have been an Access user for many years, but I never came across this needs.
As in Excel, if you have a formula that refers to 2 previous column ( ie. C2 = A2+B2), by filling in A2 and B2, you automatically get a value in C2. Is there a such function in Access?
It seems like it should exist, except I never came across it.
Please advise. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FieldC: NZ(FieldA, 0) + NZ(FieldB, 0)