Clear Table Query

H

Howie

This there a way to set up a query that will clear a table. I know I can
make a query the "makes" a table and if the table already exsist then it
deletes all the data in it. However, this also deletes the formats of the
table, such as "Index: NO, no duplicates". Is this a way to get around this?
 
K

KARL DEWEY

It is called a DELETE query.

You should periodically compact the database following deletes.
 
Top