P
Polly
Hello....this may be a little confusing, apologies I've tried to make i
simple.
I have a form with two sub forms.
Subform1 contains detailed product information (name, price etc).
Subform2 contains a summary of this information.
For example, someone puts an order together:
on subform1, they fill in all the details of the products wanted, an
these make up an element of the order (element 1 = 2 pencils,
folders, 1 postage; element 2 = 4 paper, 1 pencil)
Fields include: product, price, element.
On subform2 they fill in a summary of each element, for example
"Element 1, including pencils and folders".
Fields include: element, description
I would like to add a calculating control either to subform2 o
mainform (not sure which would be better) that shows the total cost o
each element of the order.
I think this would be conditional summing, so something like:
only add up [subform1]![price] if the element=1
perhaps?
Thank you in advance, all help is appreciated!
Poll
simple.
I have a form with two sub forms.
Subform1 contains detailed product information (name, price etc).
Subform2 contains a summary of this information.
For example, someone puts an order together:
on subform1, they fill in all the details of the products wanted, an
these make up an element of the order (element 1 = 2 pencils,
folders, 1 postage; element 2 = 4 paper, 1 pencil)
Fields include: product, price, element.
On subform2 they fill in a summary of each element, for example
"Element 1, including pencils and folders".
Fields include: element, description
I would like to add a calculating control either to subform2 o
mainform (not sure which would be better) that shows the total cost o
each element of the order.
I think this would be conditional summing, so something like:
only add up [subform1]![price] if the element=1
perhaps?
Thank you in advance, all help is appreciated!
Poll