How to fill out the empty space with 0 in CrossTab Queries?

S

salut

When I create a Crosstab query, there are always some blank entries Because
there is actually no data in that combination. Is there anyway to give it a 0
instead of blank?Because when I export the query result into Excel, 0 instead
of blank will same me a lot of trouble revising the formulas to accomodate
those blanks. Thanks a lot!
 
F

fredg

When I create a Crosstab query, there are always some blank entries Because
there is actually no data in that combination. Is there anyway to give it a 0
instead of blank?Because when I export the query result into Excel, 0 instead
of blank will same me a lot of trouble revising the formulas to accomodate
those blanks. Thanks a lot!
Click to expand...

Use the Nz() function.

TRANSFORM Nz(Count(YourTable.AField),0) AS CountOfAField
etc....
 
D

Duane Hookom

I will generally wrap the Nz() inside of Val(...Nz().....) just to make sure
the result is treated like a numeric value.
 
Top