Sum af en kolonne ud fra en bestemt værdi

Hvad hvis du sætter en "GROUP BY KolB" på?

Nej, det virker ikke.

Det er fordi jeg har følgende:
Tabel
kolonne 1 - Kolonne 2
300      - værdi1
500      - værdi2
600      - værdi1
500      - værdi1

Forespørgslen skal se såden ud:
Kolonne A(sum værdi1) - Kolonne A(sum værdi2)
1400                  - 500

I think you will need to make a sub select

SELECT *, (SELECT sum(SomeField) from tableA WHERE [Kolonne B] = Værdi1) AS SumOfVærdi1
FROM tableA

You mean use SQL?

Yes.

I just changed the code to match table names and values, but it is asking for value1 in a pop up box when i try to save the SQL:

SELECT *, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = value1) AS SumOfvalue1
FROM table1

Table1
kolonne1 - Kolonne2
300      - value1
500      - value2
600      - value1
500      - value1

/Kim

Is value1 actually the data in the field Kolonne2?
If it is then try
SELECT *, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value1') AS SumOfvalue1
FROM table1

That's better :)

Now it's shown in this way:

SumOfvalue1    kolonne1          kolonne2
1500              300              value1
1500              500              value1
1500              600              value2
1500              700              value1
1500              800              value2
1500              800              value3

Is it possible to only have one line with totals, and then for all three values?

SumOfvalue1      SumOfvalue2      SumOfvalue3
1500              600                800

SELECT (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value1') AS SumOfvalue1, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value2') AS SumOfvalue2, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value3') AS SumOfvalue3
FROM table1

Yes - now it looks right :)

I do have a lot of records. Is it possible just to genereate one record?

SumOfvalue1    SumOfvalue2    SumOfvalue3
1500            1400            800
1500            1400            800
1500            1400            800
1500            1400            800
1500            1400            800
1500            1400            800


I have tried to change the query to show totals/sum, but that gives me a wrong result.

It's not a big problem though - I can just select the first record when I make the call to the database

SELECT DISTINCT (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value1') AS SumOfvalue1, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value2') AS SumOfvalue2, (SELECT sum(kolonne1) from table1 WHERE [Kolonne2] = 'value3') AS SumOfvalue3
FROM table1

Hvis der er point i sigte, så er terry vist i førertrøjen!~)

Det funker bare.

Both of you - thanks a lot for your time :)

Terry: please post an answer

I split the points, with a advantage to Terry - OK?

sorry, I've been busy

thanks and a Happy New Year to you both

Right back at you!~)