query

[Gunther Dawson]

How do I create an an append query that activates the append after 5 days

 

[John W. Vinson]

How do I create an an append query that activates the append after 5 days

A Query by itself cannot do this. You can write VBA code to launch the
query... but you'll have to explain, five days after what? Do you want to do
something today which will cause a query to run on the 25th, to run every five
days henceforward, or what?

 

[Gunther Dawson]

I would like the append query to automaticly activate 5 days after the the
data was entered on the form

 

[John W. Vinson]

I would like the append query to automaticly activate 5 days after the the
data was entered on the form

You'll have to explain.

If you enter data twice today, once tomorrow, once next Tuesday, do you want
two append queries to run next Monday, one next Tuesday, one next Saturday? If
the fifth day is a holiday, can you count on your database being open; or will
you want something like Windows Scheduler to automatically open it; or will
you want it to be run the next time the database is opened?

What data will be appended - onto what - for each query? The data that was
added via the form? If so where is it in the meantime?

Please post some background. What are you trying to *accomplish* with this?