Merge More Than Two Queries at once
Coming from an Access based system where I could merge(Union) as many queries at once that I wanted to(I had one where I merged 20 different queries at once) , it is very discouraging and time consuming to be restricted to doing two at a time. Query List isn't an option because it doesn't refresh the records. Merging queries removes duplicate records and this is necessary when combining groups that may fall into various types of criteria.
Please add an option to merge multiple queries at once!!!
-
Tammie Cach Abdu
- May 16 2017
- Reviewed: Voting Open
Related ideas
This is an integral tool for my job. I use it often and do not want to work harder and longer.
This would be a fabulous addition! Often in order to get a full list of constituents for a newsletter, event invite, etc. I need to combine multiple queries identifying different groups and it isn't possible to do them all in one or two queries. I often find that any query looking at giving summary information needs to only have that criteria and nothing else in order to run in a reasonable amount of time. Please add this to our tool belt!
This would save so much time.