Find the most popular book in a library

[Karolis]

Hi, I'm making a database for a library as a school project and I would like to find the most popular book in the library. How do I find the most commonly repeated entry from the field "Tittel" in a table called "Lån" (I store all the transactions in this table). I tried to search but i couldnt find anything....

Karolis

 

[trucktime]

Title

You can do this in a query.

Make a query based on the table with the field 'Tittel' and a field with the Expression: Count: Count(*)
In the properties set Unique Values to Yes.

As a result you will get a list of Tittels with in the next column a count how often the Tittel occurs in your table.

If you're only interested in the top value sort the field Count Descending and in properties set Top Values to 1

 

[DLB]

What trucktime means is a Totals Query (click on the Totals button on the toolbar or select menu View, Totals.)

In the Totals Query, you don't need to set the Unique Values to Yes.

~

 

[Karolis]

Ok, thank you