Report To Print The Desired Correspondence?
Q: I need a report to print out all the places (creditors) a person owes money to. The report is set up to print on a label format (name , branch address1 ,2, 3 and Postcode) The problem is this ; If the person owes money to the Halifax it is often the case that this will be sent to a debt collection agency. If a debt collection agency is involved, 3 different addresses can be printed out (creditor, Debt Collection Agency or Both.) I've set up an 3 combo boxes to store the values so the user can input where the correspondence is to go. I'm assuming that I need a query and a report setup. So how do I set up the report to print the desired correspondence?
A: - Probably this can be done by setting up a query so to collect the parameters from the comboboxes and use them to get the right addresses. Definitely the aim should be to have the query return one record per address that needs to be printed, the