good to know. i was beating my head against the desk the last couple of days.

i don't supposed i could trouble you for the sql command to go about extracting the year from the datestamp? would it be a DATEPART expression? if i had that, i could figure out the rest.

thanks!