G
Guest
I have a subform for a purchase order database that contains the product
information. Anyway, I have text boxes which are calculated fields on each
line. For example, someone is ordering paper. They fill out the price and
quantity and it calculates the total price for each product. You can order
as many products from one company as necessary. In the footer of the
subform, I am attempting to sum all the line totals from above, then I have a
text box that pulls that value to the main form, but am having no success!
The formula I have now is =Sum([LineTotal]) which is the name of the
calculated field. Any ideas? Please help!
Thanks!
information. Anyway, I have text boxes which are calculated fields on each
line. For example, someone is ordering paper. They fill out the price and
quantity and it calculates the total price for each product. You can order
as many products from one company as necessary. In the footer of the
subform, I am attempting to sum all the line totals from above, then I have a
text box that pulls that value to the main form, but am having no success!
The formula I have now is =Sum([LineTotal]) which is the name of the
calculated field. Any ideas? Please help!
Thanks!