Help with multi-facet report

[buddyleee5]

I have a database with 3 separate tables that is tracking a small law offices billing. There are the invoices, payments, and expenses paid for filing fees etc. which are all based on a table of the customers. I need to create a report that displays the invoices with a total, the payments with a total, and the expenses with a total filtered by a selected client at the top- I've gotten close to what I want but not quite. The final issue that I have is that I need to display a balance or payment due by subtracting the invoices and expenses from the payments after the report is sorted.

Is this possible? Any help is appreciated

 

[buddyleee5]

Can anyone help with this?

 

[buddyleee5]

Can someone point me to where I could find the information on how to make this work or provide some assistance?

 

[buddyleee5]

can anyone help?

 

[Simon_MT]

I don't know the running order however there are two approaches.

If there is a FeeID that these all relate or if it just the ClientID you can create queries to total Expenses and Payments and Invoices to FeeID or ClientID. you can now establish a balance but creating a control to do the maths.

Alternatively, you can use sub-reports and put a total on the footer and then create a control and by using putting this on the Footer to create your balances.

It is Christmas afterall, I'm just loading my IPod with music but I not surprised that you have not got much sense out of the forum, today.

Simon