Difficult crosstab values

StefanSch

Registered User.
Local time
Today, 23:59
Joined
Jan 18, 2003
Messages
136
I have a crosstab query with the following settings:
rows: dates
columns: articles
Values: Numbers

how can I always add the number 2 to each value and not only to the first value?

Example

As it is now As it should be

3 5 (3+2)
5 9 (3+2+2+2)
6 12 (3+2+2+2+1+2)
9 17 (3+2+2+2+1+2+3+2)

FYI: The above numbers are running sums

any Ideas?
 
Sorry, the format has been screwed


Example

___________________

As it is now

3
5
6
9
etc.

_________________

As it should be

5 (3+2)
9 (3+2+2+2)
12 (3+2+2+2+1+2)
17 (3+2+2+2+1+2+3+2)
etc.

_________________


FYI: The above numbers are running sums
 

Users who are viewing this thread

Back
Top Bottom