Multirecords on one report

  • Thread starter Thread starter David Cleland
  • Start date Start date
D

David Cleland

Hi all

I am trying to get multiple record's fields on a single report - when I copy
and paste the field name on the report it just repeats the details of record
1 but I want record 2 and when I paste again record 3 ?

any ideas ?

David
 
Answered in your post to the "microsoft.public.access" newsgroup
Click to expand...

I don't see it there - I am told I have to add a small bit of code before
the field name when copying and pasting ?

David
 
Here is my reply from the ng "microsoft.public.access":

David,

Dragging multiple instances of the same field onto a report is not the way
to display multiple records in the report. The number of records which
will be displayed in a report is controlled by your report's Record Source
(a Table or a Query).

For example, say you have a Table with 10 records containing the following
fields: CustomerName, CustomerAddress, CustomerCity and CustomerState and
you want to display these fields in a horizontal row in your report for each
of the 10 records in your table. Drag each field into your Report's Detail
Section so that they are arranged in a horizontal row; there should be only
one instance of each field (now called a control). (There will probably be
labels associated with each field, but these can be handled later.) Now,
reduce the size of the Detail Section by dragging its bottom border upward
toward the fields/controls. Click the Preview icon and you should see all
of the records in the Record Source of your report.

Or, better yet, you can use one of the Report Wizards and let Access design
your Report, so that you can see how it is done for a variety of report
styles.

hth,
 
ah Thanks I get it, although I want to create a room map of boxes and in the
boxes are a single field from each record ?

David
 
If you could provide more detail about your report requirements, I'm sure
someone can assist.
 
Thanks

What it is - two columns of boxes that represent table layout I calling out
a name field from a table of record and I want a name in each box. There are
12 boxes on the page.

Thanks again


David
 
David,

I think you are still trying to tell us "how" you want the report to be
created, instead of what you want the report to show.

If you have a table or query containing data that you want to appear on a
report, I suggest that you use the Reports Wizard to create your report. To
use the Reports Wizard, simply click "Reports" in the database window, then
"New" and then select "Report Wizard", "AutoReport: Columnar", or
"AutoReport: Tabular". Follow the prompts to tell Access the name of your
table or query and select the fields which you want to appear in your
report.

If what you want is a list of the Names of Fields in a Table (or Query),
then from Access' Main Menu, select Tools|Analyze|Documenter.
 
Back
Top