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.