sum of a field

[buddyel]

I have a form based on a query that prompts for a particular part number. what I would like the value of a textbox (txtYTDCO1) to equal the sum of all values in the QTY field for that particular part number. Can anyone help?

 

[jjonesal]

Does the form contain other detail level fields or just summary info? J. Jones
jjones@cybrtyme.com

 

[buddyel]

The form consists of two labels, and 4 textboxes. The query that the form is set to uses all the fields from the table.

 

[buddyel]

The form consists of two labels, and 4 textboxes. The query that the form is set to uses all the fields from the table.

 

[buddyel]

The form consists of two labels, and 4 textboxes. The query that the form is set to uses all the fields from the table.

 

[jjonesal]

To use the sum function, you'll have to be summing a field (not a control on the form). You could include the field to be summed in the detail section of the form. (even if you need to hide it that's okay). Then, include an unbound field in the footer section that uses a Control source of:

=sum(fielda)

where fielda is your fieldname


Or, you could do the calculation in the query...

J. Jones
jjones@cybrtyme.com

 

[buddyel]

How would I do the calculation in the query so that it sums the QTY field for all records returned in the query.

 

[buddyel]

How would I do the calculation in the query so that it sums the QTY field for all records returned in the query.

 

[jjonesal]

You could not do it in the same query, but you would do it in a separate group (or aggregate) query. J. Jones
jjones@cybrtyme.com