Hi all,

I have what I think is a rather a curly question:

Is there a way to select all days in a month (or week, year, any
period) without having matching rows in a table?

So in essence, can I create a query that returns all the days in a
period without looking up a table?

To give some background, I am trying to output records for a graphing/
reporting tool and I only have non-zero records in my table.

Any insights, suggestions are warmly welcomed!

Thanks.