Hi,

You can do it like this:

Select Min(Year), Max(Year), Description from YourTable
Group By Description

This works on the QueryAnaliser of SQL Server. I think it works with the SQL version for VFP. Check it out and say something!

Cheers,

Ricardo