Well, it looks like you were right with column, first off. Secondly, except in rare circumstances you don't want to store calculated values in your tables. Or repeating columns.
The first thing I would do is make a query that does that totalling for you and base any forms or reports on that query instead of the table. That way, if you update one of the columns that change will be reflected in the total automatically.
SELECT A, B, C, A + B + C AS TheTotal FROM tblWhatever
The next thing I would do is read up on Normalization. you can find a ton of resources by googling for it. I've got a great article by Paul Litwin copied on my website called "Fundamentals of Relational Database Design" that I recommend to a lot of people. Your table could use a bit of restructuring according to the rules of Normalization.
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.