Help For Total Count!

  • Thread starter Thread starter DANNY
  • Start date Start date
D

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!
 
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.
 
Back
Top