| | |
|
|
|
conditionally calculating |
|---|
| message from Polly on 18 May 2004 |
Hello....this may be a little confusing, apologies I've tried to make it
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, and
these make up an element of the order (element 1 = 2 pencils, 3
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 or
mainform (not sure which would be better) that shows the total cost of
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!
Polly
|
|
Archived message: conditionally calculating (Microsoft Access Database)
