Link to home
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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
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)