I have been asked to write a report in a certain way, but I can't get my head around how to do it in access (or in SQL and pulling the table into access). I am open to suggestions even if I need to re-write the tables and how the data is imported.
I have collected data that is in this format...