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!!
 
You must log in or register to reply here.

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

Similar Threads

Access Create option group without using wizard? 2
Adding a new field to an existing report 4
Can't create a report from my query in Access 1
New User - adding to an existing report 1
Importing Text Files Into Access 1
total multiple calcualtions in a report 2
Adding Criteria to Access Reports 2
Statistical Report to the Legislature 6

Back
Top