I have two separate forms that have embedded subforms where I need totals to show in the main form. For one of the forms it is working great. On the other form it is not working.
The field on the subform is a calculated field (LineTotal):
=[MSRP]*[Quantity]
this works, but when I put when I put
=Sum([LineTotal]) in the footer it is returning an error
I thing if I can figure out my mistake here I can get through the rest of this