SUM each individual column

[dave_the_bear]

I am trying to get the total in each column but it doesn't seem to be working?

The SUM of 004 should be 3808 but it comes up as 82844?
The SUM of 008 should be 88 etc..

Then the numbers seem to be adding? As the result in each column is getting bigger and bigger

This is my SQL:

SELECT SUM(004) AS 004, SUM(008) AS 008, SUM(011) AS 011, SUM(012) AS 012, SUM(013) AS 013, SUM(014) AS 014, SUM(015) AS 015, SUM(016) AS 016, SUM(017) AS 017, SUM(018) AS 018, SUM(019) AS 019, SUM(020) AS 020, SUM(022) AS 022, SUM(023) AS 023, SUM(028) AS 028, SUM(029) AS 029, SUM(035) AS 035, SUM(036) AS 036, SUM(037) AS 037, SUM(040) AS 040, SUM(041) AS 041, SUM(044) AS 044, SUM(045) AS 045, SUM(046) AS 046, SUM(047) AS 047, SUM(048) AS 048, SUM(050) AS 050, SUM(052) AS 052, SUM(055) AS 055, SUM(057) AS 057, SUM(059) AS 059, SUM(060) AS 060, SUM(062) AS 062, SUM(064) AS 064, SUM(066) AS 066, SUM(070) AS 070, SUM(072) AS 072, SUM(075) AS 075, SUM(077) AS 077, SUM(080) AS 080, SUM(081) AS 081, SUM(082) AS 082, SUM(083) AS 083, SUM(084) AS 084, SUM(085) AS 085, SUM(086) AS 086, SUM(088) AS 088, SUM(095) AS 095, SUM(096) AS 096, SUM(097) AS 097, SUM(113) AS 113, SUM(115) AS 115, SUM(116) AS 116, SUM(117) AS 117, SUM(118) AS 118, SUM(119) AS 119, SUM(120) AS 120, SUM(121) AS 121, SUM(122) AS 122, SUM(123) AS 123, SUM(124) AS 124, SUM(125) AS 125, SUM(127) AS 127, SUM(128) AS 128, SUM(129) AS 129, SUM(130) AS 130
FROM [QC Records];

This is the Result:

004	008	011	012	013	014	015	016	017	018	019	020	022	023	028	029	035	036	037	040	041	044	045	046	047	048	050	052	055	057	059	060	062	064	066	070	072	075	077	080	081	082	083	084	085	086	088	095	096	097	113	115	116	117	118	119	120	121	122	123	124	125	127	128	129	130
82848	165696	227832	248544	269256	289968	310680	331392	352104	372816	393528	414240	455664	476376	579936	600648	724920	745632	766344	828480	849192	911328	932040	952752	973464	994176	1035600	1077024	1139160	1180584	1222008	1242720	1284144	1325568	1366992	1449840	1491264	1553400	1594824	1656960	1677672	1698384	1719096	1739808	1760520	1781232	1822656	1967640	1988352	2009064	2340456	2381880	2402592	2423304	2444016	2464728	2485440	2506152	2526864	2547576	2568288	2589000	2630424	2651136	2671848	2692560

Any solution? Thanks

 

[bob fitz]

Try:

SELECT Sum([QC Records].[004]) AS 004, Sum([QC Records].[008]) AS 008 [B][COLOR=red]etc etc etc[/COLOR][/B]
FROM [QC Records];

BTW Have your tables been properly Normalised.

 

[dave_the_bear]

Perfect. Thanks.

 

[bob fitz]

Did you notice my question on table Normalisation. You MUST have this right before you develope your db or much of what you do could be a waste of time and effort when eventually go back to it.