Sum unbound field in form footer

[tagteam]

I am trying to sum an unbound field in my continuous form footer.

User opens car form. Clicks on button and it opens a new form with only entries from the storage table that match the id on the open car form.

The control source for the unbound field is a calculation which works and is called GrandTotal



The formula in the footer of the form is =sum(GrandTotal)

However, I get #error

i have also tried =sum(Nz(GrandTotal),0)

And that does not work either.

[pbaldy]

You can't sum a control, only a field. You can move the calculation out to the form's source, or sum the calculation, like:

=Sum(Price * Quantity)

[andy49]

Perhaps create a field in your query called totalsimilar formulae to the rowsource in your form)

Then use a dsum formula to find the sum of the "totals" which match the criteria. The dsum formula could then be the control source of the text box


Sent from my iPad using Tapatalk

[tagteam]

I have even tried to sum the fields

=sum(dailystorage)

still yields an #error and daily storage is a regular field.

I was going to just try to sum each field individually and them add them up but that wont work if I cant even sum a field. Do I need to explicitly declare the form.field or some kind of parent.field type code?

I tried =sum([Forms]![Myform]![MyField]) syntax and that didn't work either.

[andy49]

Is daily storage the name of a filed or a control?


Sent from my iPad using Tapatalk

[pbaldy]

Is the textbox in the form footer or page footer? It should be form footer.

[tagteam]

It is in the form footer.
I am using the field name in the calculation

I thought I had done this before so I checked. What I did before was create a form and then add a subform to that form. Then on the main form i could sum the items on the subform.

I think I will move to that.

[pbaldy]

If you're still having trouble, attaching the db here could help.

[tagteam]

I changed my form so that I have a main form with a continous subform and i can sum the fields at the bottom of the subform.

However, I ran into another issue. After adding 5 or six unbound fields that sum I started getting #Error in the fields and the field that I used to sum the subform on the main form says #Size!

I guess there is a limit on the number of unbound fields you can use to sum. Does anyone know what that limit really is?