Hi Cameron, In the mapbasic window, i would try this, assuming that your base table is called "data" and the variable to sum "varnum" :
set distance units "m" Commit Table data As "C:\TMP\data1.TAB" TYPE NATIVE Charset "WindowsLatin1" Open Table "C:\TMP\data1.TAB" Interactive drop map data1 Create Map For data1 CoordSys NonEarth Units "m" Bounds (-10000, -10000) (10000, 10000) Add Column "data1" (_rowid integer) From data1 Set to rowid update data1 set obj=createcircle(0,0,rowid) Commit Table data1 As "C:\TMP\data2.TAB" TYPE NATIVE Charset "WindowsLatin1" Open Table "C:\TMP\data2.TAB" Interactive Select data1._rowid, sum(data2.varnum) "csum" from data1, data2 where data2.obj entirely within data1.obj group by 1 into dt_csum It's a little weird and time-consuming, but useful when you don't have Mapbasic Hope this helps, Eric Mauvi�re EMC3 <http://www.geoclip.net> www.geoclip.net 214 B Ch des Izards 31140 Launaguet France
