Empty the table contents after running the query

[navdha88]

Hi Everyone:

I have a form based on append query. Each time when I run the form the table is filled up and a report is opened based on that query. After the report is opened I want all the contents of the table to be emptied. The table is growing each time when I run the form.

I want the codes to eleminate the contents of the table. Could someone help please.

thx

 

[BillPower]

Hi navdha88,

Create a Delete Query on the Table. It will go something like this:

DELETE ID
FROM Table1;

Change "ID" to a Field in your Table and "Table1" to your Table Name.

Regards

Bill