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,
