how to display value on query

[confuse]

hi!

im new to this and i have a problem to display a value from query to form. in query i,ve done the calculation and i want that result to display in my form.

thank you,,.,

 

[georgedwilkinson]

Drag a new text box to your form and bind it to the column with the calculation.

 

[confuse]

Thank you for the reply george, I really appreciate it.

But I have another problem which is to display calculated value in the subform to main form. I have a Form named Order and subform named Order Details. In the subform Order Details i do the calculation of total as follows:

=(((([Quantity]*[SellingPrice])*(1-[Discount])*100)/100)-([FOC]-[SellingPrice]))

and i also put a text box in the subform footer to do the sum of the total
Subtotal = Sum([Total])

and i want the result of this calculation to display in form Orders, my command is =[Order Details subform].Form![Subtotal]..but still cant get the sum value of the field Total .. Please do help,,,

I would really appreciate it, its been a big trouble to me...


Thank you

 

[boblarson]

Check out my sample here:
http://downloads.btabdevelopment.com/Samples/subforms/SAMPLE-SubformTotalOnMainForm.zip

 

[confuse]

thank you so much bob it really works....thanks for saving me....
Thanks a lot......

 

[boblarson]

Glad to be able to help.