Cross-tab quesry

[Guest]

I wish to perform calculations on the results of a crosstab query. This
raises two issues:
1) how to convert blank cells into zeros
2) how to store the cross tab table in a way that i can run another query
from it

 

[David Cox]

I am very rusty, but try:

1) iif(isnull([field1]),0,[field1])

2) Just use the crosstab query as an input to the query builder.

 

[Allen Browne]

Re #1, see:
Crosstab query techniques
at:
http://allenbrowne.com/ser-67.html#DisplayZero

Re #2, create another query, and in the Add Table dialog, choose the Queries
tab to add the crosstab query as a "table".