deleting entries

L

L

I need to know if there is any way that I can have my
database delete entries after they are there for a
specified amount of time (i have a field named Days Posted
and a field called date). Does anyone know if I can do
this, and if so how can I program my code.
thanks,
L
 
T

Tim Ferguson

I need to know if there is any way that I can have my
database delete entries after they are there for a
specified amount of time (i have a field named Days Posted
and a field called date).

DELETE FROM MyTable
WHERE DaysPosted > 90;


Haven't I already answered this one?

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top