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!!!