Hi all, Can anybody help with this please? I have a table of approx 20000 records recording data collected with a GPS receiver and an automatic logging device. The structure of the table is Lat, Lon, and then 50 columns of automatic readings ie Lat,Long, Reading1,Reading2,Reading3,etc,etc,etc,Reading50. The readings are integers between 10 and 29998 and I need to count the number of times the reading in that row falls into (say) 1000 unit bands eg 10 to 1000, 1001 to 2000 etc. Obviously the sum of the bands will add up to 50 I have tried the COUNT() aggregate function but can't pick the required band and update column doesn't give me the option of COUNT() Anybody any ideas? I'm afraid I am running out of them! Jim Jim Wilson, Hilton of Fern, By Brechin, Angus, Scotland ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]