List, The solution that I finally used was from Peter who suggested the following (as did others): "Your query can be done by using the following SQL statement (assuming the columns are called ID and Date) : Select Columns : ID, Count(*), Min(Date), Max(Date) >From Table : .... Where Condition : Group By Columns: ID This will return a table with the ID, the number of IDs in each set, minimum date and maximum date for each ID. The dates will be in numeric format (yyyymmdd). To convert them to dates do a "save copy as" of the query, open the table and use table maintenance to change them to date fields. While you're in table maintenance, you could also add another field that will contain the difference between the dates and use the "update column" command to update the new column with the difference (ie maximum minus the minimum date)." Thanks again for everyones assistance, Tom ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
