By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

Query on popular products with graph report!!!

P: 1
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!!!
Apr 13 '10 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
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.
Apr 13 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.