Sum all columns in access query.

[shod90]

Dear gents ,
Um trying to make something that i didn't made before and need help .. I already googled some websites but with no hope , I hope that i'll find my solution in that great forum.
I have a query that i need to sum all the columns in an expression even if i added a new column i don't have to add the new field in the expression.


something like the below photo.

Is there a way to do it instead of using this expression

[ranman256]

nope. thats the correct way, but normally you dont sum across columns. Could your design be wrong?
normally you sum down 1 column.

[shod90]

Yes you was right , I solved my problem by redesigning my tables , And it works.. thank you.