D
Dawn
Dear all,
I have some monthly-rotine work to do ,inorder not to write the same
queries every month,I’ve put the problem on this discussion group,and Mr. Ken
Sheridan and Mr. George Nicholson have kindly guided me as to save the
monthly data tables as the name current or previous,thus the written queries
aimed at the table named current or previous can be re-uesd.
But if I choose this way,there’s still a problem I want to trun to you for
help.
As I named two tables with table current and table previous.I do many
queries with them,I also saved those queries.And those queries are not all
generated from the 2 tables,some are generated from the queries.
When the next period comes,I replaced the table previous with the data of
table current,and downloading the table current.When I tried to re-use these
queries, because some queries depend on other queries.What’s the
opening-sequence for these queries to make sure the queries use the correct
data source?Will open all these queries avoid the open queries turn by turn
problem?
Or maybe there’s other way to solve the problem?
Best regards.
Dawn Wu
Shanghai,China
I have some monthly-rotine work to do ,inorder not to write the same
queries every month,I’ve put the problem on this discussion group,and Mr. Ken
Sheridan and Mr. George Nicholson have kindly guided me as to save the
monthly data tables as the name current or previous,thus the written queries
aimed at the table named current or previous can be re-uesd.
But if I choose this way,there’s still a problem I want to trun to you for
help.
As I named two tables with table current and table previous.I do many
queries with them,I also saved those queries.And those queries are not all
generated from the 2 tables,some are generated from the queries.
When the next period comes,I replaced the table previous with the data of
table current,and downloading the table current.When I tried to re-use these
queries, because some queries depend on other queries.What’s the
opening-sequence for these queries to make sure the queries use the correct
data source?Will open all these queries avoid the open queries turn by turn
problem?
Or maybe there’s other way to solve the problem?
Best regards.
Dawn Wu
Shanghai,China