If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Sum" question
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. |
#2
|
|||
|
|||
On Tue, 11 Oct 2005 11:05:08 -0700, Mot Seven
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
x-post from previous question | justin | Using Forms | 2 | April 13th, 2005 09:48 PM |
A report design question | Al | Setting Up & Running Reports | 3 | March 11th, 2005 09:41 PM |
How to create a query with multiple answers to a question? | Amit | Running & Setting Up Queries | 4 | November 9th, 2004 04:52 PM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |
Word question regarding TOC (newbie question)... | Herman Geerlings | Formatting Long Documents | 4 | June 4th, 2004 03:12 PM |