Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

use facts from one query in another

Status
Not open for further replies.

timida

MIS
Feb 1, 2004
43
0
0
AT
I created a report with report studio. There is query A which selects my data.
I have another query B which selects detail data - both queries are joined via the Master-Detail-Relationship.

I want to insert a calculated item (into the main query and main list) which references to a column/fact (e.g. a sum) from the detail-query.

Is this possible?
timdia
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top