Report with data from two querries

  • Thread starter Thread starter mario
  • Start date Start date
M

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.
 
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
'====================================================
 
mario said:
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.
Click to expand...


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.
 
Thanks. The simple solution did work.

Marshall Barton said:
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.
Click to expand...
 
Back
Top