Charlie, you would need to know how to make a report with grouping and sorting levels. That way you can put all of your sales data into the report and then group by customer, and then further group by each sale if you want. I cover this in Access 104.

And yes, if this is a report you need to generate on a regular basis, Access would be MUCH better suited for the task. If it was just a one-time thing, then you could do it in Excel with some filtering... but that gets tedious to do it every month. In Access, you set up the report ONCE, and then just run it with the click of a button.