how will i automatically delete the information in a table with a command (1 Viewer)

toby0595

Registered User.
Local time
Today, 09:48
Joined
Mar 3, 2013
Messages
10
Hello there i was wondering if anyone could help me with a project of mine for my a2 ICT course, my database just records end of day sales figures which are entered though a form, after they are entered the total for the day is archived. However the problem i have is that the i need some way of clearing the input table with a command in the form.

Any help would be greatly appreciated

Many thanks toby :)
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 03:48
Joined
Jan 20, 2009
Messages
12,849
Set up a button to run a delete query.
 

toby0595

Registered User.
Local time
Today, 09:48
Joined
Mar 3, 2013
Messages
10
yes that's stupidly simple,

so just run

DELETE FROM table_name;

or

DELETE * FROM table_name;
 

Users who are viewing this thread

Top Bottom