Complicated

[Ganymede]

I have basic standard form from which I create and manipulate record entries.



On that basic form, I have a multiple-entries subform that feeds a separate table. The "link" between the master form and the sub form is the record "key" on the table for master form. Thus, when I pull up a record on the master form, the subform pulls up multiple records (if any) based on the value of the key of the record pulled from the master form.

The problem is that I need to create a report that contains the multiple records from the subform on a single page.

The multiple entries on the subform consist of names and social security numbers. Basically, I just need the names on a single sheet of the report.

To that end, I realize I need to make a query that contains:
1) Data from a particular record on the master form/table
2) Corresponding data from the multiple entries from the subform into a single row on the query

Any ideas how I might do this?

A subform/query would not work because I basically need these names listed within a single paragraph on the report.

[June7]

You want to arrange the multiple records horizontally (left to right) instead of vertically.

Several methods depending on your data. A crosstab query may be one but hard to build reports on crosstabs. Review these
http://forums.aspfree.com/microsoft-...ry-322123.html
http://allenbrowne.com/func-concat.html

[Ganymede]

You want to arrange the multiple records horizontally (left to right) instead of vertically.

Several methods depending on your data. A crosstab query may be one but hard to build reports on crosstabs. Review these
http://forums.aspfree.com/microsoft-...ry-322123.html
http://allenbrowne.com/func-concat.html

Wow. Thank you How do I change to "Solved"?

[June7]

Thread Tools at top of thread. Done.