Hi,
I am trying to sum the total of a column (linetotal) on a subform and have the result appear in a text box(total) on my mainform. The control source of [linetotal] is [qty]*[unitpr].
I have tried a few different ways and still can't get the result i want. I can get the [total] to = [unitpr] by itself but not [linetotal].
Can someone please help?
I am trying to sum the total of a column (linetotal) on a subform and have the result appear in a text box(total) on my mainform. The control source of [linetotal] is [qty]*[unitpr].
I have tried a few different ways and still can't get the result i want. I can get the [total] to = [unitpr] by itself but not [linetotal].
Can someone please help?