Forum Discussion
AaronClements
7 years agoFrequent Visitor
Dynamic SQL queries that update date parameters
Hello, Apologies for what may be a very basic question, but I haven't been able to find an answer on this. I'm working with several lookup tables that run on SQL queries. I would like to refr...
v-cherch-msft
7 years agoMicrosoft Employee
It seems you may use parameters in your query like this post.Then create a new append query to append these new tables.For further,please refer to below article.
Regards,
Cherie
- AaronClements7 years agoFrequent Visitor
Thank you for your reply, v-cherch-msft. I checked that thread, but I still was unable to find a way to dynamically update strings of SQL text to adjust my query. Would I be able to do that with the solution in that thread?