Subform data into report

[jamesharris]

Hi All,

I am using access 2007. I have a subform that is linked via master/child events. When I select a company all the data records relevant to that company appears. My problem is I need to put that exact data into a report and as far as I know, you cannot set a report with child/master events.

Any ideas?

Thanks.

James.:banghead:

 

[jdraw]

Do you have a query that uses your master and child tables?
if so, try /experiment by using that to create a report.
Use the report Sorting and Grouping option to Group by Company.
See if it gives you anything usable.

 

[jamesharris]

Thanks for your quick reply.

 

[JHB]

.. as far as I know, you cannot set a report with child/master events.

What do you mean by the above - "child/master events"?