Table made from query

[Guest]

I very nicely made a new table from a table query.

The problem is how to then open the table later without it performing a
query, which takes longer..

How is this done?

Thanks in advance.

 

[Rick B]

Not sure what you are asking. If you made a table from a query, then just
open the table. If you are saying that you need to use the data found in
this query often as the data source for other objects, then you should most
likely use the query. How much longer does the query take? What is the
query doing/evaluating?

 

[Guest]

Well it appears that if the resulting table made from a table-query is
EXPORTED to another access table, it then never attempts to re-querry when
the table is opening again.. not sure how to explain it.

 

[Rick B]

I'm sorry, I still do not understand. You are exporting the results of a
query to a table and want that table to "requery"? What does that mean?

What are you trying to do with this table? Just use the query - there is no
need to make a table from the data. Almost anything you can use a table to
do can also be done from a query. Why are you trying to take the query
results and put them in a table? What do you hope to gain from this extra
step?

 

[Rick B]

For example, lets say I have an employee table. I could run a query to
pull out all the employees that work in the "admin" department. I would not
need to save this data in a separate table to use it. If I want to build a
report that only shows "admin" folks, then I simply use that query as my
data source. It will always reflect the up-to-date data in the employee
table because it reruns the query every time you open the report. If I had
saved it in a separate table, then it would be static and would not reflect
any changes in the master employee table.