add "Find and Replace" functionality in Queries "SQL view".
It will be really helpful to change/correct table names/references quickly.
Many times I need to change the base table names to a different one in a complex query with formulas that refer to table names. Currently, I need to copy the SQL to notepad, make the changes and paste it back in the SQL view. However, this resets the column ordering in Datasheet view. I think "Find and Replace" is quite basic function to have while working in "SQL View".
2
votes
Uttam Shukla
shared this idea
1 comment
-
Kent
commented
Hi Uttam, This feature has already been added recently. You may not have the version with it yet.