Is it possible to create a query which joins to totalling query to dislay names?

[wedd]

Hi experts, I would like to create a query which joins a table to a grouping/totalling query to show the names of the highest grossing films foreach year (http://www.wiseowl.co.uk/training/exercises/ex-1027.htm). Is there a way I can approach this? Do you have any examples, websites, articles, books or pesonal experices how I can do this?


Thanks for your contributions:friends:

[HiTechCoach]

Yes there is a way.

You will learn a lot by trying to figure it out on our own. Experiment! I learn a lot just from the help file.

What have you tried?