Putting a sum under a series of totals 2

[KraigC]

Ok, I am trying to add a sum to a series of totals, I placed the unbound box in the footer but it puts a total under each record entry. I am about to pull my hair out HELP PLEASE!!!
Example
PartName, Partnumber, Qtyordered, Qty Shipped
4000 4000
4000 4000
(total)

 

[sozzer]

How about:

=Sum([ControlSource])

 

[Remou]

You say
I placed the unbound box in the footer but it puts a total under each record entry.
Are you using a continuous form?

 

[KraigC]

Please excuse me but I have just started digging deeper into creating databases, I am taking night classes at OSU. I am still getting the same results when I put the formula into the unbound box in the page footer but is says error, now I have my items seperated but there is only one total showing instead of for all sections. Thanks for the help.

 

[KraigC]

sorry I am not for sure if it is a continuous form. Kraig

 

[Remou]

Have you sorted this out? If not, please post the contents of your textbox.

 

[KraigC]

=Sum([ControlSource])is what i placed in the text box now if I move the text box to the detail portion of the report it gives me a total of 0 under every item

 

[Remou]

You will need to substitute the name of the field from the table, Qtyordered, if that is it:
=Sum([Qtyordered])

There are three views for forms, you will find the list under Default View on the Format tab of the property sheet for the form. A single form would have the footer underneath each record, that is why I asked.

 

[KraigC]

I have group headers and footers in that seperate all the different items.

 

[KraigC]

ok I am getting closer to what I need I now only have the totals under each of the groups but they are still 0 getting closer!!!

 

[sozzer]

Can you be a bit clearer please?
If i understand correctly, you should have a row of bound controls in the Detail part of the form and an unbound control in the form Footer. In the unbound control, just type =Sum([Qtyordered]).

 

[Remou]

What sozzer said and ...
Group headers? Is this a report of a form?

 

[KraigC]

This is a report of a query. still working on it.

 

[KraigC]

I have the bound in the detail part and unbound in form footer.

 

[KraigC]

name footer that is

 

[Remou]

That this is a report changes a few things, for one, this is the forms forum, there is a reports forum:
Microsoft: Access Reports Forum
forum703

The easiest way to get totals on a report is to use the report wizard. If you select a field to group on, you can add a summary using the Summary Options button, this includes totals.

If you do not wish to use the wizard, you can still add a total using the method that sozzer has mentioned, but do not put it in a page footer. Put it in a report footer or group footer.

Reports are not called forms.

 

[KraigC]

Ok thanks for the help, sorry I did not relize I was in the forms postings.