"Sum" question

[Guest]

I have an invoiceing db. The tables store the invoices using a PK and links
to a Customer db using a FK. On a form, a customer's number is displayed with
all the customer's info. A sub-form calls all the invoices tied to the
customer's number.
What I am trying to figure out is how to run a total of all the "Balance
Due" from the past invoices to sumarize in a new invoice for that customer. I
would appreciate any suggestions that may help.
Thanks in advance.

 

[John Vinson]

I have an invoiceing db. The tables store the invoices using a PK and links
to a Customer db using a FK. On a form, a customer's number is displayed with
all the customer's info.

You can (if you wish) use a Combo Box to conceal the number and
display the customer name.

A sub-form calls all the invoices tied to the
customer's number.
What I am trying to figure out is how to run a total of all the "Balance
Due" from the past invoices to sumarize in a new invoice for that customer. I
would appreciate any suggestions that may help.
Thanks in advance.

Put a textbox on the Footer of the subform (it needs to be in
Continous Form view, not datasheet); set its Control Source to

=Sum([Balance Due])

This can be done on a Report as well, in the Report Footer if you're
printing just a single customer, or (by using the Report's Sorting and
Grouping feature) in the footer of the Customer group.

John W. Vinson[MVP]