Query on popular products with graph report!!!

[x7866x]

Hi I need to find out how to make a query which will show the popular products in the database by area, the database involves a DVD rental system... I have 3 tables in my database .... one with customer infromation.... one with the DVD information such as genre and one table where the loans are recorded such as date taken out, date returned, rental ID etc...

I want to create a query which will allow me to analyse popular products...such as which ones are most loaned by genre and higly rated by customers etc.... I would like to be able to show this in form of a chart/graph in a report/form where i can choose using a combo box the area to analyse the data such as most loaned by genre, rating, type etc...

PLEASE HELP!!!

[Delerna]

Not enough detail for me to give an example .... but

Make agregate queries that count the number of times each movie/genre/whatever has been rented and sort them in descending order by the number of times rented

Then select the top 10/20/??? records from them.

Now you can use those queries as data sources for your graphs.