How to display Invoice Totals per month in one Report/Screen
I have been reading through the forums but haven't found a solid answer to my issue.
Basically I'm trying to find a way of displaying Invoices Total Amounts for each month on one screen/report. That can update as each month passes. Also show every month for each year and summarize each year as well. So you can see what you have turned over for each month on one screen.
I currently have an Invoice Table which reads from and Quotation Table that in turn read of a Line Items Table. The line Items Table pulls products and clients together for the Quotation Table.
I would appreciate your thoughts.