L
Leah
My crosstab is built on one feild from a table and the corresponding feild
list table as a left-outer join. The crosstab returns the total by month for
each of the items in the field and if there were no records returns a zero
for a grand total. When I try to add the date field from the first table and
query for a specific time period, I lose all of the items with null values.
I have tried to use the NZ function, but with no luck. Either I am building
the query incorrectly of I have built my crosstab incorrectly. Would someone
please advise.
list table as a left-outer join. The crosstab returns the total by month for
each of the items in the field and if there were no records returns a zero
for a grand total. When I try to add the date field from the first table and
query for a specific time period, I lose all of the items with null values.
I have tried to use the NZ function, but with no luck. Either I am building
the query incorrectly of I have built my crosstab incorrectly. Would someone
please advise.