Duplicate report pages with select query

  • Thread starter Thread starter Rich
  • Start date Start date
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
 
Use the report's sorting and grouping.
Make the member a group and only print the member in the group header.
Put the groups he belongs to in the detail section. Then it doesn't matter
how many he belongs to.
 
Back
Top