R
Rich
Hi All,
Here's the situation... I have two tables, one with detail information
(with Unique MemberID as key), another with the MemberID and unlimited
choices for group. A member can have as many "groups" as they want to
be associated with.
I have a select query with both tables, connected by the MemberID
I have a form with the option of selecting a member and/or selecting
all/one or many groups (select list box based on groups) to run a report
on for members. With this info, I build a criteria string that gets
passed into the report in the "WhereCondition" option.
Hope I still have you....
The report is based on the query. If I run the report from the option
form and don't select a group (all groups), then I get the member listed
in the report the same # of times as the number of groups they belong
to. I have set the MemberID HideDuplicates to "Yes", which doesn't
work. If I remove the group table from the query, then I can't pass in
the group selection in the "WhereCondition" part of running the report.
I want only the member to be printed once, no matter how many groups
they belong to.
This doesn't seem like a hard thing to do, I just can't seem to get my
hands around it.
Thanks in advance,
RJC
Here's the situation... I have two tables, one with detail information
(with Unique MemberID as key), another with the MemberID and unlimited
choices for group. A member can have as many "groups" as they want to
be associated with.
I have a select query with both tables, connected by the MemberID
I have a form with the option of selecting a member and/or selecting
all/one or many groups (select list box based on groups) to run a report
on for members. With this info, I build a criteria string that gets
passed into the report in the "WhereCondition" option.
Hope I still have you....
The report is based on the query. If I run the report from the option
form and don't select a group (all groups), then I get the member listed
in the report the same # of times as the number of groups they belong
to. I have set the MemberID HideDuplicates to "Yes", which doesn't
work. If I remove the group table from the query, then I can't pass in
the group selection in the "WhereCondition" part of running the report.
I want only the member to be printed once, no matter how many groups
they belong to.
This doesn't seem like a hard thing to do, I just can't seem to get my
hands around it.
Thanks in advance,
RJC