The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.
truncating tables in MS Access
Deebaser
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
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?
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?
Deebaser on
0
Posts
EDIT: And also does not reset auto-incrementing fields, if that is an issue.