Zeros in Crosstab Queries

[Jim Jones]

Can someone remind me how to generate zeroes rather than
nulls when the 'value' is zero in a crosstab query.

Many thanks, as ever!

Jim Jones
Gaborone
Botswana

 

[Jeff Boyce]

Jim

Check Access HELP on the Nz() function (Null-to-Zero).