1

Topic: Filling weeding values from the last lines. (The rising total)

I welcome!
I can not understand with simple in any way, at first sight the task.
As by means of SQL to implement request, in which additional field value of all fields of the last line will settle up.
For example: There is table , with fields date  (date), number  (number).
How to write request that the additional field calculated number of the present and all previous ?
Studied an example at a forum, but in the core all examples with the description of implementation of an output only the previous value.
http://www.sql.ru/forum/1195256/znachen … ql-bez-vba

SELECT ., ., ., (SELECT TOP 1 2. FROM incomes AS 2
WHERE 2. <. ORDER BY 2. DESC) AS _
FROM incomes ORDER BY .

2

Re: Filling weeding values from the last lines. (The rising total)

The request is precisely necessary to you? Or then all it goes to the report? And that the report is able to consider rising totals itself...

3

Re: Filling weeding values from the last lines. (The rising total)

Akina, Generally planned to use further the report generated from request.
I will be grateful, if prompt as it probably to implement in a report format.

4

Re: Filling weeding values from the last lines. (The rising total)

Calculation of the totals with accumulation (the totals with the rising total)

5

Re: Filling weeding values from the last lines. (The rising total)

Akina, the total with accumulation is not necessary to me.
The cell containing the text of the previous cells is formally necessary to me.

6

Re: Filling weeding values from the last lines. (The rising total)

Xiaohny wrote:

the cell containing the text of the previous cells is necessary to me.

it is badly clear... Show on an example.

7

Re: Filling weeding values from the last lines. (The rising total)

Akina;
DATE / of NOMERDS/NakoplennoeZnachenie
01.12.15/DS1/DS1
01.12.16/DS2/DS1, 2
01.12.17/DS3/DS1, 2, 3
01.12.18/DS4/DS1, 2, 3, 4
It is necessary to display Accumulated value in request

8

Re: Filling weeding values from the last lines. (The rising total)

 

9

Re: Filling weeding values from the last lines. (The rising total)

Akina, Not absolutely I understand as it to implement.
How much I understood it is necessary to create function group_concat in VBA, correctly?
It is possible an example?

10

Re: Filling weeding values from the last lines. (The rising total)

There under links is both the codes, and examples... Should suffice.