Report with data from two querries

[mario]

I have a report that displays all the fields in a querry.

At the bottom of the report I want to have have a text box that displays the
sum of all the rows in a single column, using a second querry.

So I Right clicked on the text box, properties, Data, Control Source and
entered the following through expression builder (I inserted the column from
a second querry):
=qry_02!Purchase_Acres

But when I run the report, its says error. When I try to run the report I
get a message box/dialog box asking me to enter the value for
"qry_02!Purchase_Acres"

I did try to do the "running sum" in right click properties, data tab. But
it did not work.

Please help.

 

[John Spencer]

Why not try the following.

No second query needed.

You could put a control in the report's footer section (not the page
footer section) and assign its control source as

Control Source: = Sum(Purchase_Acres)


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Marshall Barton]

I have a report that displays all the fields in a querry.

At the bottom of the report I want to have have a text box that displays the
sum of all the rows in a single column, using a second querry.

So I Right clicked on the text box, properties, Data, Control Source and
entered the following through expression builder (I inserted the column from
a second querry):
=qry_02!Purchase_Acres

But when I run the report, its says error. When I try to run the report I
get a message box/dialog box asking me to enter the value for
"qry_02!Purchase_Acres"

I did try to do the "running sum" in right click properties, data tab. But
it did not work.

Why do you think you need a second query?

What did RunningSum do? How did you try to use it?

You probably only need to use the Sum functionm but I can't
tell for sure without knowing more about what you are trying
to total.

 

[mario]

Thanks. The simple solution did work.

Why do you think you need a second query?

What did RunningSum do? How did you try to use it?

You probably only need to use the Sum functionm but I can't
tell for sure without knowing more about what you are trying
to total.