T
tcb
I am using a multi-select list box to filter a report (address labels
in this case) per Allen Browne's code
(http://allenbrowne.com/ser-50.html). His works well.
In this case I am selecting Donors by Associations. A Donor may have
many Associations. Thus it is possible for the result of the query to
include the same Donor more than once, for example:
Member of Society
Board Member of Society
Having this option, the user may choose both.
In the query itself, if I unclick Show Association_CD, set the query
Unique Values = Yes, I get the result I want.
However, if I save the query, then re-open the query, the
Association_CD no longer appears in the SQL. So when I run the report
by the filter, it prompts "Enter Parameter Value".
in this case) per Allen Browne's code
(http://allenbrowne.com/ser-50.html). His works well.
In this case I am selecting Donors by Associations. A Donor may have
many Associations. Thus it is possible for the result of the query to
include the same Donor more than once, for example:
Member of Society
Board Member of Society
Having this option, the user may choose both.
In the query itself, if I unclick Show Association_CD, set the query
Unique Values = Yes, I get the result I want.
However, if I save the query, then re-open the query, the
Association_CD no longer appears in the SQL. So when I run the report
by the filter, it prompts "Enter Parameter Value".