Extract data from three tables

[sgupta]

Hi,

I have three different tables in access for employee of the month, safety suggestion of the month and safety slogan of the month. I have to create a query or report where i could display all the employees who have won more than one award in a particular year. I also need to display the name of the award they have won.

I don't know how to go about it. please help !!