How add a number in sum in the query...

[herbertioz]

I need some help on this.

I have a Sql here:

SELECT DISTINCTROW trades.ID, Sum(trades.AntallPips) AS [Sum Av AntallPips]
FROM trades
GROUP BY trades.ID;

The idea is to have a start number like 10000 and using the sum to sum antallpips. For example like this:

10000+The first number=Calc 1
Calc 1+ The second number= Calc 2
and so on....

Can someone help? Thanks in advance

 

[John Big Booty]

Try;

SELECT DISTINCTROW trades.ID, Sum(trades.AntallPips) + 1000 AS Expr1
FROM trades
GROUP BY trades.ID;

 

[herbertioz]

Try;

SELECT DISTINCTROW trades.ID, Sum(trades.AntallPips) + 1000 AS Expr1
FROM trades
GROUP BY trades.ID;

Ive tried that also, but it gives me wrong calculations. Any suggestions?

 

[John Big Booty]

I'm not sure I've grasped what you are after, could you perhaps provide sample of what you are looking to achieve?

 

[herbertioz]

I'm not sure I've grasped what you are after, could you perhaps provide sample of what you are looking to achieve?

Ok, see the example in Excel as a picture. Thats all I want

 

[John Big Booty]

OK so what you are looking for is a running total?

 

[herbertioz]

OK so what you are looking for is a running total?

I fixed it my self. The solution was:

SELECT O.ID, O.AntallPips, (select sum(AntallPips) from trades where ID <= O.ID) AS ['Running Total']
FROM trades AS O
ORDER BY O.ID;

 

[John Big Booty]

Good work