I believe that what you are suggesting is the reverse of what I want to do. I have a table with the year ranges and want to derive a table of records with one year value.

>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