multiple records per page

G

Guest

I am trying to make a report. Let's say I have 50 different customers. Each
one can have a combination of up to 10 subscriptions to different services.
How can I make a report that displays the customer's name and each
subscription, which take up 5 lines each? I want more than 1 subscription per
page.
Here is an example:
John Doe

Subscription 1
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx

Subscription 2
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
 
D

Duane Hookom

Create a query that returns your information and use it as the record source
of your report. Group by customer with a group header for the customer's
name. Place the subscription information in the report's detail section.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top