I have a crosstab query with the following elements:
rows: date
columns: articles
values: numbers
The numbers are running sums calculated in another query.
NUMBERS TODAY:
The numbers in the crosstab query according to the state today are as following (example Article A):
5
6
9
14
etc.
TARGET NUMBERS:
What I want is that each number is increased by 2. This would be as follows:
7
10
15
22
etc.
Any Ideas how I can do that in this crosstab query?
rows: date
columns: articles
values: numbers
The numbers are running sums calculated in another query.
NUMBERS TODAY:
The numbers in the crosstab query according to the state today are as following (example Article A):
5
6
9
14
etc.
TARGET NUMBERS:
What I want is that each number is increased by 2. This would be as follows:
7
10
15
22
etc.
Any Ideas how I can do that in this crosstab query?
