Cleaning House? Delete Unused Queries

Jennifer Maroney — Mon, 08 Jun 2009 19:07:00 GMT

As the years go by, the number of saved queries can grow very quickly. The more queries you have the more difficult it is to find the one you need. So what should you do? Well, you have a few options: organize your queries, add links to them on your Home page, delete the queries you no longer use, or all three! Since we've covered organizing your queries and adding links to your Homepage in previous posts, I will focus on deleting queries.

When it comes to deleting queries there are two options: delete them one at a time or multiple queries at once. To delete one query at a time, open the query and select File, Delete from the menu bar.

If you have several queries to delete, I recommend deleting multiple queries at the same time. The process is just as easy as deleting them one at a time and saves you from having to open each query. Simply select Tools, Delete Multiple Queries from the menu bar in Query. You have the option to filter by query type and format. To only display your queries, mark the Only show my queries checkbox. Mark the Delete? checkbox for each query to delete from your database and click Delete Now. Please keep in mind that you cannot recover deleted records, so make sure you mark the correct ones .

Have fun cleanin' up. Talk to you soon!

The Ledger : cleanup

Cleaning House? Delete Unused Queries