totaling values in table

[bill1one]

I have a table made up of 8 weeks. Each week has its on column with a unique value. I want the final column to be a total for that entire week. How can this be done?

 

[PHV]

I quite don't understand your schema.
Could you please post your table's structure ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bill1one]

My table looks like this

Week 1 | week 2 | week 3 | etc. | TOTAL <-- heading
----------------------------------------
3 | 4 | 4 | 3 | x <-- data
----------------------------------------
2 | 4 | 3 | 3 | x

 

[PHV]

SELECT [Week 1], [Week 2], ..., [Week 8]
, Nz([Week 1], 0) + Nz([Week 2], 0) + ... + Nz([Week 8], 0) AS TOTAL
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

First, you're table structure isn't normalized and this is going to cause you problems in the future. Secondly, you shouldn't store calculated numbers in a table. From your table description, I would guess you are "committing spreadsheet". Suggest you read The Fundamentals of Relational Database Design.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[bill1one]

Oh, That makes sense. I got it to work anyhow by totaling the values on the report, which is where I needed them to total.