Sum of a field on Report Footer

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I had created a report based on query with Grouping. In
this report,i am using a unbound textbox (txtPvsDayPrice)
and using dlookup fuction to get the price of the Stocks.
In another unbound textbox (txtPvsDayValue) i am gettting
a value for([quantity]*[pvsdayprice]). Till this, it is
working fine. Now i am trying to sum the
([txtpvsDayvalu]) in the Group Footer. But it doesn't
works.!! When I open the reprot it shows "Enter Paramater
Value" and show the "txtpvsdayvalue". How do I sum this
field in a Group Footer? Is there a way to do it?? Any
help highly appre ciated. (if my question is not clear
pls. let me know)

Thanks for any help.
 
Mac

<see my response to Tao Lin ("Question about Sum() function"), this same
day>

Jeff Boyce
<Access MVP>
 
Back
Top