View Full Version : report information taken from multiple sources


fratezone
06-29-2002, 12:42 PM
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
06-29-2002, 01:20 PM
Either use a subreport or DLookup / DSum

fratezone
06-29-2002, 01:21 PM
thanks Rich I'll give that a try.