Clear Table Contents

[GoingCrazy]

I am using list boxes to fill a table that will print a report or save as an Excel file. I was just wondering if there is a way to clear the table of its contents so it can be used again or do I have to go through the process of saving it as something else, deleting the table and making a new table?

Open to suggestions.

Any help would be greatly appreciated.

Thanks.

 

[JoeMiller]

You can either make a delete query and clear the contents or you can open the table, press ctrl+A and hit the delete key on your keyboard. Whichever is appropriate for you I guess.

Joe Miller
joe.miller@flotech.net

 

[GoingCrazy]

Many thanks. That gave me the direction I needed. I opted for the delete query since other users were involved.

 

[GoingCrazy]

Many thanks. You gave me the direction I needed. I opted for the delete query so I could automate the process.