Query Deletion

[Coach Ty]

Hello,
I have a basic question:
I have a table that is based on the results of many querys.
My Question, once the results of a query have been saved withing a table, can the query then be deleted?
Thanks for your help!

 

[Galaxiom]

Saving the results of a query in a table is generally not the done thing unless it is to produce a summary form a very large number (many millions) of records that will be deleted afterwards. Normally the original data is simply requeried as required.

But yes, once a table is created from other data the query can be deleted.

 

[Coach Ty]

Saving the results of a query in a table is generally not the done thing unless it is to produce a summary form a very large number (many millions) of records that will be deleted afterwards. Normally the original data is simply requeried as required.

But yes, once a table is created from other data the query can be deleted.

Hi Thanks for the reply and the information.
I was just wondering if the table generation is always dependent on the queries, in order to update the table everytime it's run.
I have many queries and the number continues to grow, to produce the information I require. Many formulas and combining information from different sources. So, my reference payne is becoming very busy and cluttered, full of queries.
I was wondering if I would be able to simply transfer all of the result columns for the information I need, to a few tables, and then delete the queries, or if this would'nt allow the information to be updated in the future? I don't know if the formulas, used to produce the result information, transfer to the tables with the results column, or if they remain contained within the query and the formula is always dependent on the query?
Please let me know if deleting the queries, once the table is produced, will prevent the table from being updated. Even if it contains a date column?
Again, thanks for your help!

 

[Galaxiom]

Generating new tables uses a Make table query. Once created the table is not dependent on the query. However your sitiuation sounds like the tables have new records inserted by the queries. You can't delete these. Tables cannot update themselves. They can only store records and have no ability to manipulate data.

If you don't fully understand the structure and operation of the database you should not consider deleting anything.

 

[RossWindows]

If you simply need to clean up the database window, you can write a function with all the queries as sql strings using

docmd.runsql ""

where you would insert the actual sql string of a query between the quotes. Repeat this command for each query you want to 'clean up'.
Test the commands.
Delete the original queries.