Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
total column in table
- Thread starter danieljoo
- Start date
- Thread starter
- #2
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.
Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
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.
Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question