Totals and Sum not working.

[binbin]

Hi everyone!

This currently affects all my objects, from table up to forms. My problem is that I cannot make the Totals row on the datasheet view to work, nor can I make the form footer sum to work.

Usually, I just sum a field at the footer of the subform with a textbox with a value of =Sum([Field]). Then I call that particular textbox on my mainform with =SubFormName.Form!ControlName. I have several of this controls already working. Each one assigned to a different subform, all of them working.

But when I did the same thing to another subform, I get a #Error in my totals textbox on the footer of my subform, it won't work anymore. So I checked and re-checked my syntax, they are all correct.

To check, I pressed the "Totals Row" feature of access 2010 in datasheet view, but could not make the sum value appear... however, the average, min, max, variance, deviation, etc. are all WORKING except for the "SUM."

I think something broke here... any ideas?

Thanks!

 

[PaulO]

Just taking a wild swing at this, but have you perhaps named the [Field] with a 'reserved' name?

What's the Name you've assigned the field? Whatever it is change it temporarily to [Text999], change your formula accordingly, and see if the problem persists.

 

[binbin]

Hi, swing away, I'm out of ideas.

I have named all my textboxes with prefix "txt," so I have "txtPayAmount" (recordsource: "PayAmount") inside the "fsubInvoicePaymentDetail." Then I have a sum textbox with formula "=Sum([PayAmount])" and named that textbox into txtSumPayAmount.

So normally I would call the value of "txtSumPayAmount" to a textbox on the mainform with recordsource: =[fsubInvoicePaymentDetail].[Form]![txtSumPayAmount].

However, sum is already not working in the subform itself, so any value I call to the mainform will equal to #Error. Something happened to my subform, I've decompiled and compiled already, deleted it from the mainform and re-inserted the problem subform and still does not work.

I think I have to make a new subform eek: all those formatting!) based on the same table... but I'm afraid, what if this happens again and I'm not around to fix it... I can't even fix it right now...

Thanks.

 

[PaulO]

If you're able to ZIP and Upload the database in A2003 format, and advise which Form/subform contains the errant formulas, myself (not an expert) or an expert on here might be able to assist.

 

[binbin]

Hi there!

Well, after my last post yesterday, out of frustration, I just deleted the damn heavily formatted subform, but I did make a list of the customization, but it was still a pain to do all over again.

Anyway, back to the issue. When I went back to read this thread, I tried replicating the problem, but it seems everything is working again and I could not recreate the problem. But I have a feeling it will happen sometime in the future and I will post the DB by then.

Thanks for your time.