Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Mon Mar 14 04:45:23 CST 2005
(sorry for sending previous message not compleeted....) Hi group I need a query that results in a list for a specific year, numerating all movietheaters and for each theatre a TOP 30 of movies. Is it posible, and how do I do this to create a query with the folowing result. Movietheatre X, movie 01, tickets, boxoffice Movietheatre X, movie 02 , tickets, boxoffice Movietheatre X, movie ... , tickets, boxoffice Movietheatre X, movie 29 , tickets, boxoffice Movietheatre X, movie 30 , tickets, boxoffice Movietheatre Y, movie 01, tickets, boxoffice Movietheatre Y, movie 02 , tickets, boxoffice Movietheatre Y, movie ... , tickets, boxoffice Movietheatre Y, movie 29 , tickets, boxoffice Movietheatre Y, movie 30 , tickets, boxoffice Movietheatre Z, movie 01, tickets, boxoffice Movietheatre Z, movie 02 , tickets, boxoffice Movietheatre Z, movie ... , tickets, boxoffice Movietheatre Z, movie 29 , tickets, boxoffice Movietheatre Z, movie 30 , tickets, boxoffice I see only the posiblilty to create a query for each theatre and use a union query afterwards. Or by the use of a temp table, but I don't like using temp tables... The source table looks like this. movietheatre, year, week, movie, tickets, boxoffice thx Erwin Craps Zaakvoerder www.ithelps.be/onsgezin This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be>