get value from subform??

[alfred67]

Hello

Is it possible to pull a value from a subform to put in your Query??

Example : In my subform Subitems one field is Total Tender Quantity =Sum([Tender Quantity]) and I need this number in my report/Query


Thanks

Alfred67

 

[pbaldy]

I don't see why not:

http://www.mvps.org/access/forms/frm0031.htm

 

[alfred67]

Thanks for the link. This helps me out alot

Alfred67

 

[pbaldy]

No problemo; that site has a lot of great info.