How many times books have been checked out?

This view displays TITLE, AUTHOR, IDNO, TIMES (number of times the item was loaned out). Loans are grouped by item id number.

To display more data fields in separate columns you have to group by all those fields. In this example the grouping is by B.TITLE, B.AUTHOR, B.IDNO

Click Save to save the custom view for future use.

How many times library items have been checked out (simple version)?

This view displays TITLE, TIMES (number of loans). Loans are grouped by item TITLE.

To group circulation transaction you can use item TITLE. Separate items with the same TITLE will be grouped.

Click Save to save the custom view for future use.

Question:
Is there a way to tell how many times a book has been checked out?

Question:
I am the new librarian and have not been shown how to run a report to show which books have a low circulation rate.

Answer:
You can use an SQL query to find how many times a book has been checked out.