Create a report to save paper

[ffulmer via AccessMonster.com]

Hello,

I would like to ask anyone who could help me with this.
I've got 3 tables in a many- to- many relation and would like to print data
from them. I created a query
that looks like the following:

ID Date_K Action Workers .......
1 01/01/09 Memo field Memo field Joe
1 01/01/09 Memo field Memo field Peter
2 11/08/08 Memo field Memo field Ian
1 20/01/08 Memo field Memo field Rob
2 07/02/08 Memo field Memo field Kathy
3 02/02/08 Memo field Memo field Nano

Result in my report looks similar to this:

ID Date_K Action Workers ........
1 01/01/09 Large wrapped memo
that takes half of the
page on paper
Joe
Peter
Rob

 

[Allen Browne]

Could you put the Workers in a subreport?

So,the Detail section of your main report has these controls:
[ID] [Date_K] [Action] [Subreport]

The Action text box and the subreport Can Grow.

(This assumes there's some way to query the action without the workers.)

 

[ffulmer via AccessMonster.com]

Could you put the Workers in a subreport?

So,the Detail section of your main report has these controls:
[ID] [Date_K] [Action] [Subreport]

The Action text box and the subreport Can Grow.

(This assumes there's some way to query the action without the workers.)

Thank you Allen for your reply,

Yes I did try to put the Workers field in a subreport in the Details section
of the main report
and the result is like this:

ID Date_K Action Workers ........
1 01/01/09 Large wrapped memo Joe
that takes half of the Peter
page on paper Rob
1 01/01/09 Large ................. Joe
Peter
Rob
1 01/01/09 Large .................. Joe
Peter
Rob

I can hide the duplicates on the textbox controll but NOT ON THE SUBFORM.
The Workers field repeats itself as many times as many names it has.

 

[ffulmer via AccessMonster.com]

Sorry, it wrote it incorrectly. The right is NOT ON THE SUBREPORT

 

[Allen Browne]

Not sure if you have this sorted out or not.

You said you have 3 tables: presumably something like Actions, Workers, and
ActionWorkers. If so, the main report will be bound to Actions only.

 

[ffulmer via AccessMonster.com]

Not sure if you have this sorted out or not.

You said you have 3 tables: presumably something like Actions, Workers, and
ActionWorkers. If so, the main report will be bound to Actions only.

Yes, I have 3 tables and I found the information I need in two of these
tables. One of them is a one side table the other one is the joining table. I
created a query from these 2 tables and I bounded my main report to that
query. I also bounded the subreport to the same query but to different fields.


Maybe I cannot bound them to the same query?

 

[Allen Browne]

Try binding the main report to only the Actions table.

 

[ffulmer via AccessMonster.com]

Try binding the main report to only the Actions table.

Hi Allen,

I did as you recommended it and it works.
You have saved me a few hundred of pages of paper

Thank you for your time

ffulmer