Freeze data in a query

[pjg34711]

I believe that whenever I open a query, the query refreshes, thus giving me new data. Can I stop a query from refreshing at open so that the data I've used in executive reports are always available?

 

[Beetle]

Can I stop a query from refreshing at open so that the data I've used in executive reports are always available?

You can apply criteria to a query to limit the subset of data that is returned form the table(s). For example, if you created a report that only included data up to a certain date, and it's now a month later but you want to re-run that report without any including any data that has been added in the interim you would just apply criteria to a Date/Time field that would limit the returned record set to values that are older than a certain date in the past.

 

[pjg34711]

Thanks, Sean. I'll try that.

Paul (pjg34711)

 

[boblarson]

By the way pjg34711 - just some info for you. When you "open a table" you really aren't looking at the table directly. It is actually a system query which is opening.

Queries are not like spreadsheets as spreadsheets are actual storage facilities which store data until they are changed. Queries are real time objects which pull data from what is there at the time they are run. But the data does not exist in them, they only display what the SQL of the query is requesting.

Tables are the only possible static "storage facility" of data in the database. But as you have learned in this thread, and in another, it is best to send reports out to PDF for a snapshot in time. And, if you need to use a query without a report being built and need to keep that as a snapshot, you can export to Excel or send to a PDF.