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

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.



"Peter" <(E-Mail Removed)> wrote in message
news:15B963E7-7DE2-428C-8620-(E-Mail Removed)...
>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

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".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Peter" <(E-Mail Removed)> wrote in message
news:15B963E7-7DE2-428C-8620-(E-Mail Removed)...
>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