Hi, I am trying to create an invoice query which details sub table data.
I have a record against which I store basic info including whether certain basic jobs have been conducted. When 'Yes' an invoice query finds a price in another table which it inserts. However I also have an 'Other charges' table where I can enter any additional things I want to bill against the record. This second table includes item details, price etc. and has a many-to-one relationship with the main table.
My invoice needs to show a line against each record with the basic charges (I can do this ok) and also a second, third fourth etc line with just the other charges. Then finally on the right hand side of my report it needs to add everything up to give a total.