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
|
|||
|
|||
Sub totals on forms
I have a accounting database that comprises many suppliers, who are each owed
many invoices. I want to design a form that shows on or two pages each invoice owed, subtotalled by supplier. The purpose of the form is to ask the user to select (flag) which invoices are to be paid and which are to be held. Any thoughts? Many thanks -- Peter London, UK |
#2
|
|||
|
|||
Sub totals on forms
Hi Peter
You could create a main form with a list of all your suppliers and insert a subform (in continous view) that would be linked to the mainform. When you select a supplier on the main form the details of amount owed to that supplier would be shown in the in the subform. To get the total amount owed your need a calculated text box in the sub form' header or footer totalling the "amount" field. I just (about 2 weeks ago) finished a d base that showed on the main switchboard either a sad face or a happy face - if the company was owed over £100K or not. You could do something like this on your main form - although not the faces - but maybe a red field for thoes clients who are owed over a certain amount. etc. etc Hope this helps -- Wayne Manchester, England. 2 things to remember: Enjoy whatever it is you do and the F1 Key doesn’t bite. "Peter" wrote: I have a accounting database that comprises many suppliers, who are each owed many invoices. I want to design a form that shows on or two pages each invoice owed, subtotalled by supplier. The purpose of the form is to ask the user to select (flag) which invoices are to be paid and which are to be held. Any thoughts? Many thanks -- Peter London, UK |
Thread Tools | |
Display Modes | |
|
|