First of all, this board is great. So many people posting questions and answers. I've only been using Access for a week or two so I don't have many answers yet, but once I do I'll definitely be here helping others.
My question is, how do I force a query to refresh itself when it's being called by another query? Specifically, there's a UNION query that combines the results of several other queries. Some of the source queries spit out the current date/time that the query was run, and I'm noticing that if I run the UNION query at a later date those dates are not changing. This tells me that the output of the source queries is being cached.
Is there a setting that would force the source queries to recalculate? Ultimately I am looking for a 'one button' solution that would simultaneously refresh all data and output the final combined results to .csv. Should I be looking for a way to do this using VBA?
Thanks
My question is, how do I force a query to refresh itself when it's being called by another query? Specifically, there's a UNION query that combines the results of several other queries. Some of the source queries spit out the current date/time that the query was run, and I'm noticing that if I run the UNION query at a later date those dates are not changing. This tells me that the output of the source queries is being cached.
Is there a setting that would force the source queries to recalculate? Ultimately I am looking for a 'one button' solution that would simultaneously refresh all data and output the final combined results to .csv. Should I be looking for a way to do this using VBA?
Thanks