adding

[twizzlej]

Hi

I am in the process of creating a database. i have several combo boxes and
then "Quantity" boxes what i would like to do is add a box that adds all
these "quantity" boxes and update every time another box is filled in. i
would also like this field to have a control source in a table and also set a
validation rule on this.

appreciate any help

 

[Rick B]

Well, you don't store calculated results in a table. When you need the
calculation, just perform it.

If you will search for "calculated field" you should find tons of detailed
posts on this topic.

Rick B