Recent content by Ash Skilton

Resurrecting my question. The above worked perfectly at first but have encountered a small problem where if a customer has an item on their invoice valued at £0 (which we do have every now and again) it doesn't merge the £0 item with the others causing there to be two lines for the invoice on...

Hi was hoping someone might be able to explain how to do something for me. I have a table with: Invoice Number | Customer Name | Item | Item Cost | Invoice Date | Paid | Date Paid Example of data: AK001 | A Brown | Blue Car | £1000 | 1/4/2013 | Yes | 20/4/2013 AK001 | A Brown | Red Car |...

Hi, This is going to be a complicated and maybe slightly confusing question but I will try and explain it as best as I can. I have a report that is an invoice that is set up with: Page Header Detail Detail Totals Dummy Footer < Automatically calculated size to position Report Footer always at...

Thanks Chris this solved my problem perfectly.

Thanks for the reply. One problem I encounter with this method is the report is an invoice and has Totals/Subtotals in my Report Footer which I want to be positioned under the Report Details and not at the bottom of the page? The Page Footer i'm using is for a Signature and terms of conditions...

Sorry yes that's a typo will update my post thanks :]

Hi, I'm fairly new to Access and VBA. I have a slight problem with printing a report that i'm hoping someone can advise me with. The report can have one or multiple pages and the Page Footer only appears on the last page. To achieve this I have used the VBA code: Private Sub...