how would i create a main report with two different tables/forms within it??

[andrew v via AccessMonster.com]

i would like to get a customer history report that will be able to show
what assessments they've taken as well as any orientations they've been to.
this will come from three tables: customer, assessments, and orientations.
the assessments and orientations are set up as datasheet view in the forms.
i would like it to stay like that when it's in the reports as well.

i am already able to create a customer history report showing customer info
and assessments scheduled. i would like to know how i can add the
orientations part of it into the customer history report as well. i would
like the assessments and orientation to be seperate in the report.

any suggestions???thanks...

 

[Marshall Barton]

i would like to get a customer history report that will be able to show
what assessments they've taken as well as any orientations they've been to.
this will come from three tables: customer, assessments, and orientations.
the assessments and orientations are set up as datasheet view in the forms.
i would like it to stay like that when it's in the reports as well.

i am already able to create a customer history report showing customer info
and assessments scheduled. i would like to know how i can add the
orientations part of it into the customer history report as well. i would
like the assessments and orientation to be seperate in the report.

It sounds like you want to use a subreport for each of the
two tables. The report design would look a lot like the
form's design excpet you would use subreports instead of
subforms.

 

[Duane Hookom]

If the table structures are similar, you might consider a union query as the
record source for your report.
Another solution is to create a main report based on one record source and a
subreport in the main report's footer for the other record source.