Setting zero as the default value in a crosstab

[urbanista]

I'm working with a big dataset that I want to export for
statistical use. To do this, I count records (trips) in
one table that are linked to another table (persons). The
result is a crosstab showing in the value the number of
trips by category for each person. However, I get null
values when the person took no trips in that category. I
need these null values to be zeroes for my statistical
process. Is there any way to set zero (not null) as the
default "count" in the crosstab?

Thx!

 

[Duane Hookom]

You can set your value column to something like:
Val(Nz(Count(Yourfield),0))

 

[hermie]

Format the fields with 0;;;0 (page 760 of the access bible book)

Hermie