Handling Crosstab Nulls

  • Thread starter Thread starter Scott C
  • Start date Start date
Scott C said:
Can a crosstab query be configured to replace Nulls with
Zeros?

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))
 
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"
to "Expression" and then in the
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top