Multiple records per report page in Access

[Guest]

I am trying to create a report which lists 3 contacts (per page) and their
subsequent information (ie: location, product they have, month/year sold) in
the Detail section (of the Design view). I have labels alongside data fields
pulled from the main table. Once I laid out the formatting then I copied and
pasted all cells twice. But now it shows 3 of the same record per page
instead of three different records per page. Thank you in advance.

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Marshall Barton]

I am trying to create a report which lists 3 contacts (per page) and their
subsequent information (ie: location, product they have, month/year sold) in
the Detail section (of the Design view). I have labels alongside data fields
pulled from the main table. Once I laid out the formatting then I copied and
pasted all cells twice. But now it shows 3 of the same record per page
instead of three different records per page.

The detail section is repeated for each record in the
report's record source table/query. Adding extra copies of
some controls has no effect on this basic function of
reports.

You didn't explain the most important part of your report,
its record source table/query. I'll take a guess, based on
your mention of a "main table", that the record source is a
query that joins a customer table to a contacts table. If
that's the general idea of your report, then you should use
Sorting and Grouping (View menu when the report is open in
design view) to create a group on the customer id field.
Specify yes for the the group's group header property.
Then move all the customer text boxes and labels to the
group header. Leave one copy of the contact text boxes in
the detail section and delete the copies.

 

[Guest]

You are correct. I have a customer table with a variety of info per customer.
I am pulling a few items from that table to create a contact report to submit
to our prospective clients. It is working. Thank you so much. I did not have
any information in the group header.

I am now wondering how to adjust the margins to make the information in the
report centered. I am trying to make it visually appealing as I am mailing
this to our prospects. In the design view should I adjust the margins to the
full page (8 1/2" x 11") or to the printable page (with 0.5" less per margin).

 

[Marshall Barton]

As ;omg as you want everything to be moved to the right,
adjusting the Left margin is a sensible thing to do. OTOH,
if you want some things moved farther than others, just drag
(or set the Left property) to move the text boxes as far to
the right as you want them to appear in the report.

 

[Guest]

Marshall,

Thank you for your help. I am so glad these discussions are available.
Sometimes it is hard to find answers to "easy" questions. I am sure I will
back soon.

Take care.

As ;omg as you want everything to be moved to the right,
adjusting the Left margin is a sensible thing to do. OTOH,
if you want some things moved farther than others, just drag
(or set the Left property) to move the text boxes as far to
the right as you want them to appear in the report.
--
Marsh
MVP [MS Access]

You are correct. I have a customer table with a variety of info per customer.
I am pulling a few items from that table to create a contact report to submit
to our prospective clients. It is working. Thank you so much. I did not have
any information in the group header.

I am now wondering how to adjust the margins to make the information in the
report centered. I am trying to make it visually appealing as I am mailing
this to our prospects. In the design view should I adjust the margins to the
full page (8 1/2" x 11") or to the printable page (with 0.5" less per margin).