P
Pandalus
Hello,
I am trying to create a cross tab query. I can do this, but I end up with a
lot of blank fields, which I guess are null values. I want to replace these
null values with a "0". Then export th whole thing to Excel or as a text
file so I can analyze my data.
More specifically, I want to create a cross tab query that has a list of
species across the top (i.e. as columns), and a list of the samples down the
side (i.e. as rows) and then a value for each species in each sample. I can
get this far without aby trouble. However, the nature of the data is that
many species do not xist in ach sample, thus generating a null value in many
cells. I need these to be zeros. So far I have been exporting and then
entering th zeros manually which takes forever.
In addition, sometimes I need to make a crosstab query in the above manner,
but the value itself is created from an expression. Does this change how I
can make the null values into zeros?
Thanks,
Benjamin
I am trying to create a cross tab query. I can do this, but I end up with a
lot of blank fields, which I guess are null values. I want to replace these
null values with a "0". Then export th whole thing to Excel or as a text
file so I can analyze my data.
More specifically, I want to create a cross tab query that has a list of
species across the top (i.e. as columns), and a list of the samples down the
side (i.e. as rows) and then a value for each species in each sample. I can
get this far without aby trouble. However, the nature of the data is that
many species do not xist in ach sample, thus generating a null value in many
cells. I need these to be zeros. So far I have been exporting and then
entering th zeros manually which takes forever.
In addition, sometimes I need to make a crosstab query in the above manner,
but the value itself is created from an expression. Does this change how I
can make the null values into zeros?
Thanks,
Benjamin