Phone List Report

[Lou Burgoyne]

I have two tables. One is Members and one is phone numbers. A member
may have zero, one or multiple phone numbers.
I have a query that links all members and their phone numbers. I want
to create a report that displays the member only once, with all of
their phone numbers.

Any ideas?
Lou

 

[Duane Hookom]

You can set the Hide Duplicates to Yes on the member names text box.
Otherwise, you can create a group header for the member name. Another
alternative is to base your main report on the members and create a subreport
(possibly multicolumn) for the phone numbers.

This all depends on how you want the names and numbers displayed which only
you know.

 

[Marshall Barton]

I have two tables. One is Members and one is phone numbers. A member
may have zero, one or multiple phone numbers.
I have a query that links all members and their phone numbers. I want
to create a report that displays the member only once, with all of
their phone numbers.

Typically, that kind of report is done using Sorting and
Grouping (View menu) to group on the member name. That way
the member name text box would be in the group header
section and the phone number field in the detail section.