Hi!
I am not an expert, so I have probably a stupid problem. But it is driving me crazy 😊
Example:
I have a Table with, for example repair cases on my equipment. I have created a crosstab query which counts me a number of those repairs cases in each quarter of a year. So my crosstab query use to have one row (Number_of_cases) and 4 Columns (Quarter1, Quarter2, Quarter3, Quarter4).
So far so good, but since right now is beginning of a year (February), number of cases in Quarter2, Quarter3, and Quarter4 is zero. Consequently those columns are not even created in my crosstab query, because they are empty. Therefore all other objects like Reports, Graphs referring to this non-existing column are now reporting an errors, but works fine in the end of a year 😊.
How can I avoid that, without silly trick, creating one “shallow” case for each quarter in my original table?
I want that all columns are created even if they contains 0.
Thanks in advance for your help!
Beginner 33