Duplicate report pages with select query

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.
--
Dave Hargis, Microsoft Access MVP


"Rich" wrote:

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