Have you tried to copy the table select the 30 then delete the set,
or add a column then do a column update to the selection and add a
value for the selected 30 to the column then do a select search for
the 'non' value in the column
er any more out there
Adrian
>
>These are very simple questions, but I can't seem to find any easy
>answers. I have a table of 100 records with 30 of those selected.
>How do I switch my selection so that it contains the other 70
>records instead? (The thirty records represent items which I wish
>to have excluded from the original set of 100.)
>
>Also, what's the quickest way to sort a table by a column? Can this
>be done without outputting a "select" query into a new table?
>
>TIA
>Andrew
>
>---------------------------------------------------------------------
>Get free email from CNN Sports Illustrated at http://email.cnnsi.com/
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
******************************************************************************
* _
*
* |_|/~\----^\_ Adrian Walls, North Wales
*
* _/_ * :. 14 Tyn Llan,Llanferres,Denbighshire,CH7 5SP, UK *
* // | :' [EMAIL PROTECTED]
*
* - \ : [EMAIL PROTECTED]
*
* / : http://www.nwmba.demon.co.uk
*
* \ : [EMAIL PROTECTED]
*
* / : AOL Instant Message Username : MacMTBman *
* __/ :
*
* /~ :. (web mail) [EMAIL PROTECTED]
*
* ~\-__ :
*
* `--_ ___- :
*
* \___/
*
******************************************************************************
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]