Sub totals on forms

[Guest]

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

 

[Guest]

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