how can I open a query without running it

[lyndah]

Can someone advise how I can open a query without it running automatically? I have a query that takes a while to run on a large database and sometimes I want to see the results from the last time it ran
thanks
Lynda

 

[MajP]

A select query has no persistent effects on the database, the results are not written or stored anywhere. It is only a set of instructions on which fields, records, and order, to present. When you close the query view there is nothing saved.

You would have to run a make table query or an append query to save the results into a persistent table.

Maybe you can describe the query and tables and we can help optimize it to run faster.

 

[JoeAtWork]

I want to see the results from the last time it ran

As MajP says, the only way to do that is to save the results somewhere (a new table, copy and paste into Excel, etc.). As soon as you close a query it's data is lost, it does not "remember" any previous results.