Hi thx for the article write up....appreciate it.

so my months are sorting alphabetically instead of by datetime

APR

AUG

DEC

FEB

ETC

D'Oh!  Such a pain how do I fix?

Oddly enough, I have a stored proc that is called by Excel through ADO however Excel will crash everytime giving a generic error UNLESS I have the WITH RECOMPILE clause...