Calculating subform fields

[RuralGuy]

Not yet but the temp has been dropping for the last week. I'm hooking up the snow thrower.

[Missinglinq]

Amazingly, after a Summer like you'd expect in Death Valley, we're actually having Autumn weather here in the South East! Last year Summer went til December and then Fall until April! Winter popped in for 2 entire days, with four inches of snow that was gone by Day 3!

Don't forget that firewood!

[RuralGuy]

Got the wood already.

After removing the formatting values on the control and setting it to just Currency, summing the controls work as well. Just an FYI.

[Tvanduzee]

Genius, absolute Genius.......... Thank you so much
It even got it resolved "before" ALL my hair went missing.

Thank you so much
Terry

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>

[Tvanduzee]

On the same form, I have a field in the subform called Markup.
This field needs to be the Cost * 40% (1.40). If I change the control source to reflect this, it will become unbound. I tried putting =[WO_Details_Cost] * 1.4 in as the default value, but got a blank field. I tried creating another textbox and assigning the control sourse as [WO_Details_Cost] * 1.4 and the value appeared in the new txtbox, but the Markup field remained blank.

How can I have the value of Markup appear in the subform on each row of details?

Thank you
Terry

[RuralGuy]

Do your calculation in the query and then bind the control to this calculated field.

[Tvanduzee]

I salute you all. Great Job with assisting me.... Thank you.

Terry

[RuralGuy]

Again, glad we could help.

[Tvanduzee]

One last thing on this.
I entered an expr in my query that took the cost * .4, which calculates the way I need it.
In my form, I pointed the control source for "Markup" to the Expr field in the query, and it shows fine in the form. However, I need those values to be put in the table.
Is there any way to do that? Logically, I can't see how it would be possible.

Thank you
Terry

[RuralGuy]

Calculated values should not be in a table in most cases. Just calculate them every time you need them. Having said that: http://allenbrowne.com/casu-14.html