rodneygray
asked on
All footer totals show #Error when only one footer total has an error.
I just ran into a problem with Access 2010. Simple form with totals in the form footer. I had an error in one of the 5 total fields on a tabular form. ALL total fields turned to #Error.
This is an easily repeatable problem. Create a tabular form with four or five columns that can be summed. Then, add unbound fields in the footer to hold the totals. Create the totals correctly by using the formula (=sum([RegularHours]). Do this for all fields that can be totaled. View the form and all totals will be displayed correctly.
Now, change the footer total fields so one of the fields has an error (ie. Instead of referring the actual field name (RegularHours), use the control name (txtRegularHours)). All sum fields will now display an error. It took me a couple of hours and lots of head scratching to figure this out.
This must be a bug. I don't think it is a program "feature".
Does anyone know how to report this to Microsoft?
This is an easily repeatable problem. Create a tabular form with four or five columns that can be summed. Then, add unbound fields in the footer to hold the totals. Create the totals correctly by using the formula (=sum([RegularHours]). Do this for all fields that can be totaled. View the form and all totals will be displayed correctly.
Now, change the footer total fields so one of the fields has an error (ie. Instead of referring the actual field name (RegularHours), use the control name (txtRegularHours)). All sum fields will now display an error. It took me a couple of hours and lots of head scratching to figure this out.
This must be a bug. I don't think it is a program "feature".
Does anyone know how to report this to Microsoft?
I believe the footer is like a the header and can't calculate a field until the data has been processed. I bet if you copy and paste the text box with the calculations into the body section, it will display correctly.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, the detail section.
The detail section is displayed for every record - you can't sensibly put totals in there.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry Harfang, that sounds a little like Clinton : “"It depends upon what the meaning of the word 'is' is. If 'is' means 'is and never has been' that's one thing - if it means 'there is none', that was a completely true statement."
If you spend a couple of hours trying to determine what the problem is, it "is" a bug. Is there any other development software that does the same thing? And, I don't remember this happening with 97 or 2003.
Whatever, it was most frustrating to arrive at a reason for the problem.
By the way, I do appreciate your analysis. You have helped me in the past and I respect your knowledge of the product.
If you spend a couple of hours trying to determine what the problem is, it "is" a bug. Is there any other development software that does the same thing? And, I don't remember this happening with 97 or 2003.
Whatever, it was most frustrating to arrive at a reason for the problem.
By the way, I do appreciate your analysis. You have helped me in the past and I respect your knowledge of the product.
Try this:
Do for one field and repeat for other fields:
Assume field1: control source: c1
In detail section copy field1, and paste, rename field to rsField1
properties
Format - Running Sum: Over All
Data - Visible: No
In footer insert a text box: field1Total:
Properties
Data- Control Source: = rsField1
Do for one field and repeat for other fields:
Assume field1: control source: c1
In detail section copy field1, and paste, rename field to rsField1
properties
Format - Running Sum: Over All
Data - Visible: No
In footer insert a text box: field1Total:
Properties
Data- Control Source: = rsField1
ASKER
hnasr,
I see what you are doing. My point is this. Why should users have to use such convoluted logic to accomplish a simple thing like sums at the end of the form? Once the error is corrected, all fields show the correct sum. But, finding out where the problem exists when there are multiple sum fields, is the issue.
I see what you are doing. My point is this. Why should users have to use such convoluted logic to accomplish a simple thing like sums at the end of the form? Once the error is corrected, all fields show the correct sum. But, finding out where the problem exists when there are multiple sum fields, is the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The only correct solution to this issue would be for Microsoft to address it. I feel like Dorothy approaching the Wizard. Hopefully, this post will help other's who are stumped by this "design flaw".
And, I don't remember this happening with 97 or 2003.Yes it does happen the same way in Access 97. I just tried it.
ASKER
Thanks IrogSinta. I don't have those software versions any longer.