Cross-tab quesry

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top