Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

keeping track of last filtering 1

Status
Not open for further replies.

ps

Technical User
Jun 26, 2000
2
SE
i have a problem, i want my database to be filtred every 30:th day and se which data that are old and remove this data. How should i create this procedure? I realise where to type the code(when the form is opened, then...), but i don´t know how to write the code.
I have the filter procedure alive and kicking, but i need something to keep track of when the filterprocedure was last done.
Thankful for answers.

 
You can just when you're openning a database to run (via autoexec macros) a

delete from YourTableName where datediff(d,YourDateColumnName,now())>=32
[color] John Fill
1c.bmp


ivfmd@mail.md
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top