adding values

[skate]

is it possible to add the values in my subtotal column (in a subform) and display it in the main form?

 

[tanalee]

Aloha...

Yes, it is possible.

What are your field/control names?

Tana

 

[skate]

This is what I have:

Size 1 - Pipe: $/item, qty, price$
Elbow: $/item, qty, price$
Tee: $/item, qty, price$
Subtotal = (add 3 price$'s)
Size 2
Size 3
etc.

Each size is a new entry/record. I want to add my subtotals. Is there a way?

 

[tanalee]

Aloha...

I'm not a programmer, but I think this is the right direction.

On your subform, create an invisible textbox. Make the textbox equal to FirstPriceField + SecondPriceField + ThirdPriceField. (Hopefully they don't all have the same name, as it appears). I believe it's:

=Sum(FirstPriceFieldName + SecondPriceFieldName + ThirdPriceFieldName)

Then make a textbox in the main form which equals the text in the subform. I think it goes:

MainFormTextBoxName = SubformTextBoxName

I gotta run, so I can't verify any of this.

Sorry.

Tana

 

[David R]

If [Subtotal] is a calculated field in your subform, one in each record, then you should be able to put a text box = Sum([Subtotal]) in the Footer of your subform (may have to enable Form Footers).

Then as tanalee said, you can make a box on the main form to refer to that field, if you really need to.