subtotal field kicks back #error in the footer!

[julius1]

Hi there. I have created a subform that allows me to add multi line material lists for orders. I have placed the below text field in the footer of the form. When I point it to sum the extendedprice field it kicks back #error
=Sum([extendedprice])

My extendedprice is setup with the following control
=[extendedcost]*0.1+[extendedcost]which shows the amounts fine and accurately for each line item.

The form is currently in form view, the end result when it totals correctly will be come a subform in datasheet view to allow multi line entries joined by one workorder.It's subtotal will be displayed in a linking text field in the main form.
Any ideas on what I did wrong or how to fix it would be most appreciated. Thanks

 

[ptpaton]

Make sure that your field and your text box are not named the same. Then you might get an error. If you have a field named extendedprice, and a text box named extendedprice, you'll get an error becasue Access doesn't know which you intend to sum. You can fix this by renaming the control, such as calling it txtExtendPrice. Be careful after chainging the name of the control that Access doesn't change the name in the code for the Control Source. (Access sometimes thinks it's smarter than us humans!)

Let me know if that works.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[RoyVidar]

If ptpaton's suggestion does'nt work, try:

=Sum([extendedcost]*0.1+[extendedcost])

Roy-Vidar

 

[julius1]

ok, actually they both work. Thank you very much guys, didnt think about the naming errors