Is it possible to "apply" a set analysis expression as a normal selection?
I have a number of set analysis expressions (in variables) that I use as data filters for a few fields, but it would be really useful to be able to re-use them as to apply the selection described in the set expressions as a normal selection.
I know about the "select in field" action, but aside from being a lot of work to define ~10+ selections on fields in this way for several controls, I'm not even sure it's technically possible to define some of the set expressions as a consecutive number of selections. Some of them involve reducing sets and selecting nulls by removing all data that has value in certain fields, which would translate into some "Select X in field Y" + "Select excluded in field Y", which doesn't work when there are more of these constructs since select excluded would select other data as well that has been excluded for another reason in an earlier select statement...
By double quotes do you mean the double quote (one char), or double single quotes (two chars)? They are not equivalent in set analysis, so it's likely the former won't work, but the latter seems to work for me when I want to embed single quotes inside a quoted string (they are turned into a single quote in the actual string, and there is no need to play around with Replace() )
And by impossible I meant that if more than one field is involved, there are states that just cannot be represented as combinations of selections in their respective listoboxes (lots of cases involving a sum of sets, for example) - if you use this method to select first in one field, then in another one, the final result won't be necessarily the same as what the set describes. If it's about a single field, then don't worry about it.
Hi, thanks, I figured it out, if I do it the other way around; if I use double quotes in the set expression and single quites on the "only"-part as you suggested, then it works. I removed that part of my answer, but it seems you started writing your answer before that, but thanks again!
