I am working up a report to pull information off of our databases to help automate the faxes and emailing of invoice information for PO’s to customers. It’s close but here is my hang-up. I have all the information appended into three files, then brought together with a query. My report has the data grouped together by invoice# with general information which there is only one record of per invoice in the group header. In the detail section of the report, I have the line item information from the invoices which can be multiple lines per invoice along with a field(s) from invoice notes which can also have multiples depending on how many lines of notes were on the invoice. It works fine if there is only one line item, it prints the line item plus the notes. If there is more than one line item, it prints the notes next to each of the line items (even when I click the option to not include repeated information). When I try to put the note field in the summary section either above or below the detail I only get one line of notes instead of however many there are. Any suggestions on what I can do here?
