Filtering a Report

[buddyleee5]

I am building a database to track invoices and payments for a small law firm- I have all of our clients set up in a client table, and then I have made a separate table for invoices and another for payments. I am now trying to figure out the best way to make a client "statement" showing the invoices and the payments for each client.

Ideally I would like to make a report where at the top there is a drop down of our customers and when a customer is selected there are 2 subreports- invoices and payments that are sorted by date for the client that was selected at the top- how do I make it so that the reports are based off of the selection at the top? Is it possible to make a form that I select the Client from the drop down and then use a button to execute a report based on that selection?

Also is it possible to have the totals of the payments subreport subtract from the invoices? and how are the dates on the subreports built?

 

[vbaInet]

Too many questions, each of which should have gone in separate threads.

Starting with your first question, yes it is possible. Create the form and the report and have a look at this:

http://baldyweb.com/wherecondition.htm

Ensure that your report displays all clients.

As an off topic, the law firm should have more than enough money to hire a professional to pay and get this done

 

[buddyleee5]

No need for the snide remark- if everyone just "paid professionals" places like this forum wouldn't exist.

Now if you'd like to put your "professional" skills to use and tell me how I would add a total box on my form that subtracts one subreport total from the other I'd be very grateful.