Using Data from 2 Tables in a Report 1

[peterpcu]

Hi,

I have two tables, one called 'Contracts' and one called 'Risks'.
I have built a Report which includes the Risk table data and that report works fine. I have also built a report based on a query using the risk table data and that also works fine.

How can I include data from the contracts table in the header of the reports?

Regards

Pete

 

[Remou]

It depends on what you want to do and the relationship between the two tables. It may suit to include a subreport based on contacts or to build a report based on contacts and include a subreport based on risks, or even to build a report based on the two tables joined in a query. It is even possible to use DLookUp.

 

[peterpcu]

Hi Remou,

Brilliant, I tried constructing a sub report and including it in the main report - it works a treat.

Many thanks for you excellent help

Regards

Pete