T
Tom
Dear All,
in my database, I am recording projects in different categories. I
have now created a crosstab query that sums up all project per
category and year, including a total number of projects per year.
How can I also show, how the total number is changing compared to the
previous year? Basically, I am looking for something like (No of
projects of previous record's year-No of projects of current record's
year)/(No of projects of current record's year) at the end of each
record.
A B C Total Change
Y1 3 2 5 10 0 %
Y2 1 7 6 14 + 40 %
Y3 2 2 5 9 - 36 %
Sorry, the answer may be really simple, I just can't see it.
Regards
Tom
in my database, I am recording projects in different categories. I
have now created a crosstab query that sums up all project per
category and year, including a total number of projects per year.
How can I also show, how the total number is changing compared to the
previous year? Basically, I am looking for something like (No of
projects of previous record's year-No of projects of current record's
year)/(No of projects of current record's year) at the end of each
record.
A B C Total Change
Y1 3 2 5 10 0 %
Y2 1 7 6 14 + 40 %
Y3 2 2 5 9 - 36 %
Sorry, the answer may be really simple, I just can't see it.
Regards
Tom