I started off to begin with with spaces and a load of reports/queries and it was a pain in the bum changing the reports/queries whenever I changed the table name, so I decided to just leave it.
I did try that however I assumed that if I wanted one invoice, I would have to have 'Line Items' which would allow the database to store multiple products per invoice. If I done all one, I don't think I can do that.
Open sorting and grouping, group on Quantity. Move the field [Quantity] into the Quantity Header. Place all other fields into Report Detail. If you want, you can put a summary for Quantity into the Quantity Footer as well.
Ok - and one more question Chris, thanks for being patient with me.
On a form where the customer details come up, is there a way for me to have a button to go directly to such an invoice without me putting in the criteria [Insert Customer ID] for Customer ID field and [Insert Invoice ID] for Invoice ID field?
On the form, say an 'Area X Customers Form', perhaps a button that would say 'Generate Invoice' and it would bring up that invoice without me having to input those details such as Insert Customer ID & Insert Invoice ID?