Using data from multiple quierries in a report

[Tim C]

I have developed a report that needs to pull data from 2
different queries. Most of the data is gathered from the
query that that is the record sorce for the report.
However several of the calculations need to come from data
in a different query.

What would the expression look like to cause a control to
look to a to a different query and total the values of the
records in a particular field in that query.

Thanks in advanced

Stumped in Harrisburg !

 

[Marshall Barton]

I have developed a report that needs to pull data from 2
different queries. Most of the data is gathered from the
query that that is the record sorce for the report.
However several of the calculations need to come from data
in a different query.

What would the expression look like to cause a control to
look to a to a different query and total the values of the
records in a particular field in that query.

Without knowing how the data in your two queries is related,
it is really difficult to guess how this can be done in a
meaningful way.

Taking your question literally, you can calculate the total
of a column in another table/query using something like:

=DSum("[particular field]", "different query")