Counting

[ddrew]

I have a form (frm_Entries) with a textbox (BagCount) on it. I also have a subform (frm_Bag) which is a continuous form, there is a textbox on the subform called (Qty).

If I have, for example 3 records in the subform with the (Qty) showing 3, 4 and 3. I want the textbox (BagCount) to show the total, in this case 10. I cant find a count function that I have used in the past to cover this. Could somebody help please?

Many thanks

 

[Beetle]

Place a text box in the footer of the sub form and set its Control Source to;

=Sum([Qty])

 

[ypma]

Would not a query of the source of the frm_bag with the field qty , then in the Bag count use a [FONT=&quot]DSum("[Field_name]","qry_name")
My understanding is that count will count records ! I am using ac2010 and can produce an example of what I mean if that would help.
Regards

[/FONT]

 

[ypma]

Sorry Beetle ,posing my reply at the same time. Your solution is far easier than mine i did not think of it myself ..