Grouping

I have three tables that I am using in a query to create my report: Personal
Data, Phone Info & Skills. The phone info table contains multiple records
for the same vendor. I want the phone numbers to print one right under the
other; similar to the below format.

Last Name, First Name Stick
Home Phone #1 Jeep
Cell Phone #2 Bobcat
Other Phone #3 First Flake

Right now, each phone number creates a new listing.

Yvette,

One approach would be to make a Group Header based on the person, and
put the names in there, and the phone numbers in the Detail section.
Another approach would be to make a subreport for the phone numbers. I
am not sure of where the Jeep, Bobcat, etc come into the picture.

--
Steve Schapel, Microsoft Access MVP


YVETTE wrote:
I have three tables that I am using in a query to create my report: Personal
Data, Phone Info & Skills. The phone info table contains multiple records
for the same vendor. I want the phone numbers to print one right under the
other; similar to the below format.

Last Name, First Name Stick
Home Phone #1 Jeep
Cell Phone #2 Bobcat
Other Phone #3 First Flake

Right now, each phone number creates a new listing.