open the Northwinds database that comes with access. Then open the Employee Sales by Country report. It will ask you to input dates (choose betwen 1994 and 1996). Switch the report to design view to see how the achieved it, then try copying for your own report.