All,

I have a field of dates that some collections occured. I am needing to compile a report that has the years collected (i.e. 2000,2002) Has anyone done this, and if so, could you point me in the right direction.

Thanks,
Kevin

select distinct year(datefield) from table

this will return unique years that exist in the field specified.

Thanks!!!!