Yes, this is a job for access reporting.
best thing is to create a query (sounds like you have that already) and then base the report off of that.
You can set it to only display certain items when they break, and a summary line by using grouping. The report wizard should walk you through it.