delete and reset

[Help an Access Idiot]

How can you set a database table up to automaticly delete
and reset for next days data?

Thank you ahead of time for any assistance.
Packskum the pathetic.

 

[SK]

Create a Delete Query in the database and then run this
either on Database exit or on Database Open as it fits to
your situation.

Dim Delete As String
Delete = "qry_Delete"
docmd setwarnings true/False 'to see confirmation of the
deletes.
DoCmd.OpenQuery Delete, acViewNormal, acEdit
DoCmd.Close acQuery, Delete