Append/Delete Queries

[donnan33]

I have an append query and a delete query. The append asks a parameter (like employeename) when appending. I want to be able to append the to my archive table and then delete same person from original table without having to give the same parameter twice.....right now I have them running one then oterh but I have to type in the name twice for both queries.....



Is there a way to run it and only have to type name in once?

[pbaldy]

You could have the user type the parameter into a form textbox and have both queries get it from there.

By the way, it is often not a good idea to do archive data. Usually you'd just have a "status" field of some sort in a single table. That let's you query active employees, old employees or both, just by adjusting criteria.

[donnan33]

Thanks, I am just trying to get rid of old employees from my employee list when they leave then . i do want to save them in a separate table then delete them from my list. I also have other fields i will be needing o remove expired wo's from my list save them in another table and then delete them from the lookup list. what would be the best way to do this?????

[pbaldy]

If you want to use the second table then the append and delete queries are probably the best way.