Hi,
Thanks for the instant reply. But what if the combinations for which the data doesnt exist are rows. After looking at your post i went back to the SQL view of the crosstab query and understood where you are talking about adding columns.
But then in the output that i see now from the query...
HI in this thread Cosmokramer mentioned:
"Are you trying to say that you want the "D-F" value to appear as a crosstab column, even if no "D-F" records exist???"
I have a similar problem. I am trying to make a quarterly report and i want 0 to appear if there we no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.