G
Guest
My question is this - when you have a crosstab query, with a count as the
value, and there is no vaules in the data, so the field is blank in the
output, what type is that field. It does not appear to be null (nz(field),0)
gives me an error) or a blank or a zero.
What I am trying to do is to take the results of a crosstab query on a
report and then from there add up the values to get a row total. when I try
to add values that are blank, I get nothing, but if I only add columns that
have a value, the result is correct.
Any ideas?
value, and there is no vaules in the data, so the field is blank in the
output, what type is that field. It does not appear to be null (nz(field),0)
gives me an error) or a blank or a zero.
What I am trying to do is to take the results of a crosstab query on a
report and then from there add up the values to get a row total. when I try
to add values that are blank, I get nothing, but if I only add columns that
have a value, the result is correct.
Any ideas?