Calculations in crosstab queries

[Treeny]

I have a crosstab query that displays the following:

Column 1 Column 2 Column 3 Column 4

Player1 5 2 3
Player2 5 2 3
Player3 3 1 2

All I need to do is express columns 3 and 4 as a percentage of column 2 but I'm getting errors saying that my field names are not valid.

Is it possible to perform calculations within crosstab queries?

 

[SydneyGeek]

Hmmm...

this often happens if you try to use newly created field names in the query where they were created. Try basing a second query on the crosstab, and doing your percentages there.

Denis

 

[Norie]

What do the numbers represent totals/sums/counts?

What formula are you using to try and get the percentages?