besides what Tom said.. another facet of the same issue.. when you do a 
"NOT" query, it gathers all the potential results, from whatever other rules 
are part of the query, then deletes the ones that are "NOT".. you can have a 
200 meg, empty Answer table, if you started out with a 200 meg real table


--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"bob shin"  wrote in message news:59bc9d10$1@pnews.thedbcommunity.com...


Hi

I am using following query delete function to delete and to reduce file size
but the file size in window is the same.

ex  before query delete
number of rec = 669035
file size 487186 kb
index size 1654 kb


after deleting 99% of the records the file size is

number of rec = 150
file size 487186 kb
index size 1654

Records were delete but the system file size does not change.

I have refreshed and reopen the folder to verify but still the same.  Also
when I run a query the table it take as long, when the records size was 
669035.

Any idea?


qbe = query

:workretail:ginv#  | date |
delete |<~date1|

EndQuery
qbe.createauxtables(true)
qbe.executeqbe()



bob shin