Handling Crosstab Nulls

R

Rick Brandt

Scott C said:
Can a crosstab query be configured to replace Nulls with
Zeros?
Click to expand...

Yep.

In design view there will be one column with a crosstab heading of
"Crosstab" and a total heading of "Count" or "Sum" etc.. Lets use "Count"
as an example. Change the setting "Count" to "Expression" and then in the
Field where you now have something like....

The Value: ID

Change to ...

The Value: Count(Nz(ID,0))
 
S

Scott C

Rick,

Thanks. It worked like a Charm.

Scott
-----Original Message-----


Yep.

In design view there will be one column with a crosstab heading of
"Crosstab" and a total heading of "Count" or "Sum" etc.. Lets use "Count"
as an example. Change the setting "Count"
Click to expand...
to "Expression" and then in the
 
Top