I'm having a major brainfart this morning. I've created an mdb file with step by step queries that are so easy a caveman could do it. The only problem is that Im starting with appending a null table (lets call it table1) and when I finish table1 is still all populated with data and shit.
How can I clear out the data in table1 using a query as I don't trust these mouth breathers to manually delete the entries in table1 and I can't be assed to run this report on demand?
Posts
EDIT: And also does not reset auto-incrementing fields, if that is an issue.