Formula in Access column

yballan
yballan used Ask the Experts™
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
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)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial