Help For Total Count!

[DANNY]

I got a link table about 7 columns, but I need write a total count of whole
data,
see below:

part# S1 S2 S3 S4 S5 S6
ASD 1 22 33 1 2 4
BCD 121 3 4 6 7 3

How to write code to change this table to
part# Total
ASD 63
BCD 144

Your help is much appreciated!

 

[Duane Hookom]

You can use
=S1+S2+S3+S4+S5+S6
If you might have null values, you may have to use Nz(S1,0)+...

This type of operation sometimes suggests un-normalized table structures.