Report with data from two querries

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.
 
J

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
'====================================================
 
M

Marshall Barton

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.


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.
 
M

mario

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top