Link to home
Start Free TrialLog in
Avatar of yballan
yballanFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Partha Mandayam
Partha Mandayam
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
but I would advise against a calculated column, unless the computation is long or calls a function.  Generally, I would simply create a query that is based on your table and insert a column with that computed value.  Keep in mind, that in Access NULL + Anything = NULL, so to get a value even if one of the fields is empty, you need to use the NZ( ) function:

FieldC: NZ(FieldA, 0) + NZ(FieldB, 0)