Create a report from Form which includes a subform

[pjtessi9]

Hi folks,


I'll try to explain best what I am trying to accomplish.

I have a form which contains a subform. The relation of those 2 tables are one to many, which means that for Form1 contains unique values and Form2 can have multiple values linked to it.

Example: In Form1 there is a FILENUMBER. For that FILENUMBER, there can be muliples values in FORM2 (PERSON)
RAI-200101-001 can have PERSON1, PERSON2, PERSON3

The form is working great and displays the results I want. Now I want to be able to create a report that shows each FILENUMBER with the PERSON in it like:
RAI-200101-001 PERSON1
PERSON 2
PERSON3

Presently, the report shows me a line for each PERSON like
RAI-200101-001 PERSON1
RAI-200101-001 PERSON2
RAI-200101-001 PERSON3

Like I said, the data comes from 2 different tables that have a relation from one to many

Is there a way that each entry from FORM1 SHOWS ALL THE PERSON LINKED TO IT BASED ON FILENUMBER LIKE ON A SINGLE LINE INSTEAD OF MULTIPLE LINES

Thank you so much for your help!

[orange]

See this from Allen Browne
and this sample

[CJ_London]

not sure what you are saying -

this

Now I want to be able to create a report that shows each FILENUMBER with the PERSON in it like:
RAI-200101-001 PERSON1
PERSON 2
PERSON3

or this?

Is there a way that each entry from FORM1 SHOWS ALL THE PERSON LINKED TO IT BASED ON FILENUMBER LIKE ON A SINGLE LINE INSTEAD OF MULTIPLE LINES

which implies

RAI-200101-001 PERSON1 PERSON 2 PERSON3

[pjtessi9]

Is there a way that each entry from FORM1 SHOWS ALL THE PERSON LINKED TO IT BASED ON FILENUMBER LIKE ON A SINGLE LINE INSTEAD OF MULTIPLE LINES

I want the FILENUMBER found in table FORM1 to show all the data associated with it from FORM2 to show up in the report.
Some FILENUMBER will only have 1 entry from FORM2 or can have multiple entries.
I want the report to sort by the unique FILENUMBER and show all the PERSON from FORM2
Now what I get in the report is
FILENUMBER and PERSON1
on a second line, I get FILENUMBER and PERSON2
on a third line, I get, FILENUMBER and PERSON3 and so on.

[CJ_London]

Repeating what you have already said does not clarify what you are asking. Under the circumstances, suggest use a crosstab query.

[orange]

pj,
Ajax asked specific question in post #3. Please answer the question so readers understand what you are trying to accomplish.