I designed a report that groups by month. When I run a report for a full year I want to show the name of the month above each section. Using the datepart function only gives me the number for the month (i,e. 1=jan, 2=feb, etc.) I want the actual name of the month to show on my report at the start of each section. How can I do this.
Thanks for your help.

Don't use the datepart function, just change the format propery for that field's control to:

"mmmm"

That will display your month as, say, January

Thanks for all your help. Works great!