[quote user="emurphy"][quote user="Manni"]
I'm also confused about why you would want a function that automatically deletes all the records out of a particular table? Don't people like to keep records?
[/quote]
I'd guess a work table. Access seems to be big on multiple "populate this table with a variation of what's in the previous table" steps.
Access also has this retarded idea that "DELETE * FROM TABLE" means you should delete the table itself, not just the data within it. I'm sure there's some simple way to delete just the data, but I intentionally keep my Access knowledge as limited as I can get away with...
[/quote]I love when people criticize things they have no clue about. Why don't you try running "DELETE * FROM Table" in MS Access and let us all know what actually happens*. Then, you can offer your opinion as to whether or not it is "retarded".
As for "populate this table with a variation of what's in the previous table" -- that's up to the programmer. Nothing about Access forces or even encourages you to do this. You can write one query after another to maniuplate a recordset and never create a single row in a single table (i.e., you can use queries as derived tables).
*Hint: It deletes all rows and not the table.