Hi
I am very new to Microsoft Access and am self learning.
I have a report that I would like to generate on a query previously done (Customers, Orders & Products).
I would like to have the 'Customers Name' followed by Text of 'Monthly Exceptions' in the page header. The idea is that each new page would have a new customer name and all orders for that customer on it. I have tried a text box but this won't update the customer name an all pages.
Also I know how to force a page break but I don't know where in Design View is should be inserting it to get a new customer and their orders on the next page?
Any advice would be greatly appreciated.
Thanks