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]

Reply via email to