Even better.

Well, there I go posting before thinking things through fully. Turns out that I could use:

SELECT

...

LEFT(DATENAME(mm, '2003-' + datafield + '-01'), 3) AS MonthName,

...

to get what I want. Still seems...

quote:

---

Just wondering.... do you really have to have tables for each month? How about just one table and either:

a) queries that...

Robert,

I, too, found this to be a great "Best Practices" article on SP development. Allow me to add my voice to those who would be interested in reading your take...