I am trying to generate robust reports.  For instance, this database is for a Bike Rental program.  I am trying to generate robust reports for each bike (how many times it was check out, who checked it out, when it was checked out, the service status history of each back etc.). 

I learned that I currently am only able to see the current status of my current bikes and clients. Therefore, in order to see the robust history, I would need a report to generate the history and all the changes.

Is there a way to do this?

I say report, because I am trying to avoid scripting. I believe what I am asking is a very common type of report, so I think it is there some where, I just do not know where.

Let me know if you need more information.

I attached a picture to better explain myself. I created a report, and as you can see, when I click on the Bike Serial #, it only gives me one row of information. I would like to have a new row for every change recorded on that bike.