adding up fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report with the wizard. How do you calculate fields? In my design view I created a text box, when I double click it and go to the ALL tab, then to control source, I can't find the right formula to add up my field. I need to add up all the requests I get for each state. Please help!!
 
I am not sure what you mean with adding up all requests,
Let us assume you have field called ReqAmount which
contains the number of items requested.
In order to display the sum of all requested items at the
bottom of the report, you would ente a new textbox in the
report footer and enter "=Sum([ReqAmount])" without the
quotes.
This will than display the sum of the items requested.
Similarly you can also count([ReqAmount]) to show the
number of lines etc.
Hope this helps.
Fons
-----Original Message-----
I have created a report with the wizard. How do you
Click to expand...
calculate fields? In my design view I created a text box,
when I double click it and go to the ALL tab, then to
control source, I can't find the right formula to add up
my field. I need to add up all the requests I get for
each state. Please help!!
 
Back
Top