Really struggling to copy an Access Report
I am in the last stages of completing a database based on an old MS Access (97!) DB that is nearly defunct.
I am currently designing the reports part of the solution and have completed most except the overall order comparison report. I have attached a screen grab. It is designed to show the total orders from each month and year since the company started. It shows the year, month name, Nett total and order count.
I have no idea where to start as unsure of what layout mode would be best to show this data, or the use of portals etc. Or is there a better way to report this?
My layout that has the required fields is called Invoice details. I am here to provide more info where necessary
Thank you for tor time