a second query in a report using the same parameter 1

[joeblow3]

Hi:

I have a report based on a query, say Query1.

Now I want to include in the report, a field (SumofQuantity) based on a second query, say Query2.

Both Query1 and Query2 have the same parameter needed to run them.

Is this possible? Initially I used the expression builder to say: "=Query2!SumofQuantity" in the control source of the textbox that I want to hold SumofQuantity.

But this doesn't work. Any ideas?

Thanks in advance.

 

[dhookom]

Are you using parameter prompts? If so, IMO dont faq701-6763.

Duane
Hook'D on Access
MS Access MVP

 

[joeblow3]

Thanks dhookom!