Thanks Bill. That is a good idea. I think in my situation it would be better to create the seperate table. My sales table has millions of records so that extra field would take up more space. If I go with the seperate table of dates and corresponding fiscal months, I would only need one record...
Thank you for the reply, but perhaps I was not clear. Maybe an example would help. Let's say I have a table of sales information. One record per day, and the number of sales for that day. If I group by DatePart month, I can see the total number of sales for the entire month. Like so ... SELECT...
