Accumulated value

[Fred]

Hi people! I would like to create accumulated column in access query,but I don´t know how do do it....Can you help me? Thanks!


CLIENT SALES ACCUMULATED COLUMN
a 12 12
b 11 12 + 11 = 23
c 8 23 + 8 = 31
d 5 31 + 5 = 36
e 4 36 + 4 = 40

 

[lawtonl]

This should work

accumlated column: [Client]+[Sales]

 

[Fred]

Not worked! The result = #Error

SQL Instruction:

SELECT Table1.ID, Table1.Cliente, Table1.Vendas, ([Table1]![Cliente]+[Table1]![Vendas]) AS [accumlated column]
FROM Table1;





accumlated column: ([Table1]![Cliente]+[Table1]![Vendas])

 

[Fred]

I would like to accumulate SALES column and generate 'Accumulate column!'!

CLIENT SALES ACCUMULATED COLUMN
a 12 12
b 11 23
c 8 31
d 5 36
e 4 40

 

[Fred]

Query Coluns/Values

Client Column = a,b,c,d,e

Sales Column =12,11,8,5,4

Accumulate Column=??????

 

[Brianwarnock]

Can you not produce a report and thus use a running sum.

Else do a search for running sum on the queries forum here and you will find several hits.

Brian

 

[Fred]

Please see my example db1.zip
Can´t I did this kind of report, with these columns... a column do accumulate sales value ? Tks