header and body side by side in reports - is it possible?

  • Thread starter Thread starter enos76
  • Start date Start date
E

enos76

Hello,
I am trying to build a report with two columns, from a query: on the
left column I would like to have fields from table 2, on the right
column I would like a single text field from table 1, that spans all
the rows.
Please, is it possible? I am using Access XP.

Here is an example of what I mean:
id_a description_a
1 Little boy blue come blow your horn. The sheep's in
the meadow...
id_b id_a
a 1
b 1
c 2
a Little boy blue come blow your
b horn. The sheep's in the meadow...

Any hint is much appreciated. Thanks, regards.
 
I expect you could use a main report based on the unique id_a values from
TableA. Add a subreport in the detail section based on TableB. Set the link
master/child properties to the id_a fields.
 
Duane said:
I expect you could use a main report based on the unique id_a values from
TableA. Add a subreport in the detail section based on TableB. Set the link
master/child properties to the id_a fields.
Click to expand...

I had already accomplished through the wizard: the problem is spanning
a single "memo" field of the master among many rows belonging to the
child.

report:
child_field mmmmmaaaaa..
child_field ...aassssttteeee....
child_field ....eeeerrrr_field

Thanks,
 
There should be no issue with a can grow text box on the main report bound to
the memo field and a subreport on the left with multiple records.

+----------------+ +-------------------+
| child a | |Little boy blue |
| child b | |come blow your |
+----------------+ |horn. .... |
| |
+-------------------+

+----------------+ +-------------------+
| child c | |Row row row |
+----------------+ |your boat, gently|
| |
+-------------------+
 
Duane said:
There should be no issue with a can grow text box on the main report bound to
the memo field and a subreport on the left with multiple records. [...]
Click to expand...

You're right, a subreport will do.
Thanks a lot Duane, you saved me much time and frustration.

Best Regards
 
Back
Top