I have a series of queries each counting a different month to make up a quarterly report by month... don't worry about that if it sounds confusing, just realize that I have 1 query that contains 12 other queries, each counting a different month.
Well - everything works fine - it counts the records for the previous months perfectly - but when it gets to months with no data - instead of the query returning a blank field, it returns NO fields. It just shows the field headings. This normally wouldn't be a problem, but when it is in with a series of other queries - when ONE query returns NOTHING the whole mass-query goes bad and the report will contain no data.
What am I doing wrong? And why is this query not returning a blank field?
Well - everything works fine - it counts the records for the previous months perfectly - but when it gets to months with no data - instead of the query returning a blank field, it returns NO fields. It just shows the field headings. This normally wouldn't be a problem, but when it is in with a series of other queries - when ONE query returns NOTHING the whole mass-query goes bad and the report will contain no data.
What am I doing wrong? And why is this query not returning a blank field?
