We help IT Professionals succeed at work.

calculation in access

Last Modified: 2013-11-27

I have a column in access that contains a number. I would like to create another column that has the difference of that number from 30. For example if the first column contained the number 17 then the second column would contain the number 13.

thanks for your help
Watch Question

Use design view on the table to create the new column then use an update query to do the calculation and update the new field.
pls explain with proper example

If this is always the rule then you should not be storing the second value at all.
You can always calculate it whenever you need it.
If you store it there is a fair chance that the two values will get out of synch and no longer add up to 30.

Also, to do this you would have include code in your data entry form to calculate the second value and drop it into a textbox bound to the second field.

You cannot do things like this in the table design.

Unlock this solution and get a sample of our free trial.
(No credit card required)
While the query I have shown will do what you ask I agree with Peter57r that what you are suggesting is not usually a good idea
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.