For those of you who asked me to post any solutions I received from the following question I posted, here they are... "I selected objects on a map and want to see all the records that are not selected. Is there any easy way of listing the records that are NOT selected in a table?" Some of the answers: Pick a unique field in the table (suppose it's called "State" and the table is called "States") then in the SQL select dialog, choose your table name, States, in the "From tables" edit box, but in the "where" edit box, put "State not in (select State from selection)", without the quotes. Or substitute Query1, Query2,... whatever... if "selection" is not available. (This seems to be the SQL solution. And it's probably a good one. But for some reason it takes me forever for me to run a query and I never got to see if it worked in the end because I couldn't wait that long. My table is an Access97 Database table with over 9000 records. One unique field is indexed in MapInfo but still seems to be very very slow. Can anyone give me solutions on how to speed up my Access Database queries in MapInfo?) or You could select everything from the layer using select all, then un-select the objects in the view with the shift key. What you have left is everything not on the map (This also seemed to be a good solution. But for some reason I can't un-select objects on a map with the Shift key using the Marquee select tool. Seems that I can only do that with the regular select tool , and there are to many records to un-select one at a time. Does anyone know how to unselect using the marquee tool or a un-select group of objects on a map view at once?) or Select * from States where (your selection criteria) click the selection table & delete it. Now the records left in the original table are the one which are not in selection. You can save it as some other table & then close the original table without saving. Don't save the original table as it will get saved with deleted records. Thanks for all the help, Dan ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
