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

Blurred text
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)