Subform not displaying all records

[Rpettis31]

I have a query that takes information from three tables to create a report.
My problem is some of the data is from a subform that can have multiple
records that need to appear on the report. When I run the report instead of
all the linked records appearing I have several copies of the same report
with one record from the subform list on each of the report. My question is
how do I get all the records from the subform on the same page.

 

[Pete D.]

When you build the report you must group by the same field that relates the
main form to the sub form and then the report will do the same.

 

[Rpettis31]

I am not following what you have stated here. I am trying to have all the
records from a sub form appear on one report as opposed to having record one
of the subform which is associated with record one of the main form yet
record two of the subform which is linked also to main form one.

 

[Pete D.]

I get from what you are saying that page one of report prints one copy of
the main form and one record of the subform. Page two writes another copy
of the same record from the main form and the next record from the subform.
Reports relate to records the same as a form/subform. The report must know
that you want to group all sub-records of the main-record to the main record
on the main form. So you must group them under the main record. For
instance

Grouped
Computer A has
Mouse
Monitor
Keyboard

Computer B has
Mouse
Monitor
Keyboard

Ungrouped
Computer A
Mouse

Computer A
Monitor

Coomputer A
Keyboard...and so on.

Use the report wizaard and play with grouping options and see what happens.