report information taken from multiple sources

[fratezone]

I checked the forum for similar problems and came up empty. Hope someone can help me out.

I have a rpt with detailed information and that information is then followed by a summarized version with totals, min, max, etc ...

The detailed protion is not a problem and is fed from tableA however some of the summarized information must be taken from a different table/query.

I tried to link with relationship but no luck. It kept asking me to enter a parameter value.

=Sum([qryPurchaseCost_Temp]![MinOfNet])

Is there an easy way to have a report run off two tables or one table and one query, and if so how do you go about it?

Thanks

 

[Rich]

Either use a subreport or DLookup / DSum

 

[fratezone]

thanks Rich I'll give that a try.