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