How to multiply percentages in a CROSSTAB-action

[hans.chys]

I'm looking for a solution to MULTIPLY percentages in order to come to
a 'summed' total percentage via e.g. a TRANSFORM function in a
crosstab-query

Example:

record 1 - 0,95 - 2007
record 2 - 0,85 - 2008
record 3- 0.62 - 2008
record 4 - 0.12 - 2008
record ...

I want to have a crosstabquery that results in a column per year
(2007, 2008, ...) and where the total is the product (as in
'multiplication') instead of the SUM.

e.g.. for 2008, the result should give : 0,85 x 0,62 x 0,12 = 0,063...

Is this possible by using an SQL-command (which), or do I need to use
a VBA-module ?

If so, how should that module look like ?

Thanks for sharing your ideas on this !!

Hans
Belgium

 

[hans.chys]

I'm looking for a solution to MULTIPLY percentages in order to come to
a 'summed' total percentage via e.g. a TRANSFORM function in a
crosstab-query

Example:

record 1 - 0,95 - 2007
record 2 - 0,85 - 2008
record 3- 0.62 - 2008
record 4 - 0.12 - 2008
record ...

I want to have a crosstabquery that results in a column per year
(2007, 2008, ...) and where the total is the product (as in
'multiplication') instead of the SUM.

e.g.. for 2008, the result should give : 0,85 x 0,62 x 0,12 = 0,063...

Is this possible by using an SQL-command (which), or do I need to use
a VBA-module ?

If so, how should that module look like ?

Thanks for sharing your ideas on this !!

Hans
Belgium

<<<<<<<<<<<< And I'm using MS Access 2003 !!>>>>>>>>>>>>>>>