Error when I add text box to calculate totals

[bapster]

I have a table called Vendors....(one field VendorName)

I have a subform based on a query with the underlying table called
purchase_orders. I scroll through the vendor table to display
the releated purchaseorders for this vendor in the subform..no problems here.
Also this po table/query includes a field called amount. My goal is to show a total of the amount by vendor. (simple huh?) apparently not for me...

I place a text box in the footer area of the subform to calculate the SUM of
the amount field, I cannot get it to work, I always receive an error (showing up in the text box where the total should be)

I would appreciate any input from anyone that may be able to help.


Thanks.

 

[Rich]

Is Amount a calculated field, if so then you have to repeat the calculation
ie =Sum(Net+Tax)

 

[bapster]

No, it is entered in a table
called purchase order...