S
swichman
I have a subform that lists quantities and unit prices. The subform is
related to the form via a task id. I have a calculated control at the
bottom of the subform that calculates total of quantity * unit price
for each item under the forms task id. I created a field on the form
referencing this cell and got the total to appear for that particular
task id. No problem. However I want another field on the form that
sums the total of all task id's quantity times unit prices. The only
way I could figure to do this was to create an expression in a separate
query and reference the sum of that expression in a control on the
form. However this is clunky since the underlying querry is not
updated until the form record is changed. Am I overlooking the
obvious? Is there a better way to do this or is there an event
procedure that would force the querry to update upon updating the
quantity and price fields on the subform??
Any help would be appreciated.
related to the form via a task id. I have a calculated control at the
bottom of the subform that calculates total of quantity * unit price
for each item under the forms task id. I created a field on the form
referencing this cell and got the total to appear for that particular
task id. No problem. However I want another field on the form that
sums the total of all task id's quantity times unit prices. The only
way I could figure to do this was to create an expression in a separate
query and reference the sum of that expression in a control on the
form. However this is clunky since the underlying querry is not
updated until the form record is changed. Am I overlooking the
obvious? Is there a better way to do this or is there an event
procedure that would force the querry to update upon updating the
quantity and price fields on the subform??
Any help would be appreciated.