sum...

select Type, sum(beløb) from boner, kalender WHERE kalender.Type="s" and kalender.relation = boner.relation GROUP by Kalender.Type

den brokker over kalender.relation

men hvorfor er det lige at denne ikke virker

SELECT Type, sum(Beløb) as [SUM]

FROM boner, kalender

WHERE (((kalender.Type)="s"));

SELECT Sum(boner.Beløb) AS SumOfBeløb, Kalender.Type
FROM boner LEFT JOIN Kalender ON boner.Type = Kalender.Type
GROUP BY Kalender.Type
HAVING (((Kalender.Type)="s"));

Use the query designer to make your query. You need a relationship between table boner and kalendar. If there isnt then you cant do this.
There is a little button in the menu like a Z press this and your query will become an agregate query where it will GROUP on all fields. Then change the beløb field to sum instaed of group By

yoyo mugs, det var også lidt forkert det du skrev men jeg fandt ud af at løse den fordi dit gav mig en ide,
her er points

Tak - hvordan ser SQL ud?