Too many Unbound sum fields

[tagteam]

I have a form that has a continuous sub form in it. I am summing the values from several fields in the form footer. however, after I get past six I get #Error.



It looks like there is a limit on the number of unbound fields you can use to sum data. Is there any way around this?

[Bulzie]

Doesn't seem like there should be a limit like you describe, there is a limit to the number of fields on a form but doesn't sound like you are there. Could the 7th sum field be an actual error in that field? Post some sample data and your code in that box.

[tagteam]

Update, it does not appear to be an issue with too many fields.

it appears that the problem occurs when I am trying to sum another unbound field.

In my continuous form have 6 fields that are actual fields in the database. Then I have 3 fields that just ubound fields used to run calculation on the fields in the table.

In the footer I can sum up the 6 fields fine but when I try to sum any of the unbound fields all the fields show #Error.

It looks like you can't sum an unbound field. Does anyone know if there is a way to do this? Do I need to add the unbound fields as calculated fields to the table?

[Bob Fitz]

It looks like you can't sum an unbound field.

In an unbound text box there can only be one figure on the current form so there is nothing to summarize.

[June7]

By 'sum' do you mean an aggregate calc? Cannot do aggregate calcs on unbound controls, only on fields. If you want to aggregate the calculated values in the unbound controls, have to repeat the calculation in the footer control. So if your calc in the detail unbound control is [Quantity] * [Price] then the calc in the footer would be: Sum([Quantity] * [Price]). Otherwise, do the simple calc in table Calculated field or in query so you will have a field that can be referenced in the aggregate calc.

[tagteam]

I was able to resolve this issue by creating calculated fields in the main table. I can then add the calculated field to the detail area of the subform and use an unbound field to sum it at the bottom.
Thanks for your help.