Re: [GENERAL] Querying all months even if don't exist

2007-02-26 Thread A. Kretschmer
am Mon, dem 26.02.2007, um 10:10:45 -0500 mailte Robert Fitzpatrick folgendes: > I have a query that pulls totals for the month and from there I am > building a crosstab to show all months. My dilemma is that sometimes > there is no data for a month and the crosstab becomes skewed. I made a > tabl

[GENERAL] Querying all months even if don't exist

2007-02-26 Thread Robert Fitzpatrick
I have a query that pulls totals for the month and from there I am building a crosstab to show all months. My dilemma is that sometimes there is no data for a month and the crosstab becomes skewed. I made a table with all the 12 months in it and joined to the query in my view to get all the months