Creating Access Report

[math20]

Hello there,
I am trying to create an access report that looks like this:

Sales Report
Location Saless Person Name Banana Apple
SalesPerson 1 1 2
Sales Person 2 2 1
Sales Person 3 3 1
Kitchener Location Total 6 4
Sales Person 1 2 1
Sales Person 2 2 2
Sales Person 3 2 3
Waterloo Location Total 6 6
Grand Total 12 10

2nd part: Sales Effectiveness

Location Saless Person Name Banana Apple
SalesPerson 1
Sales Person 2
Sales Person 3
Kitchener Location Total
Sales Person 1
Sales Person 2
Sales Person 3
Location Total
Waterloo Grand Total
I created the first part the Sales Report part, I am having problem creating the second part of the report the Sales Effectiveness.

This is the Design View of the report:
Report Header
Banana Apple Sales Report

Page Header
Date:Comes from the Form Banana Apple

Location Sales Person Name Sales Sales
Detail
[SalesPerson Name] [Banana Sales] [Apple Sales]

Location Footer

[Location]Label:Location Total =sumofbanana' =sumofapple'

Page Footer
Report Footer
Grand Total
If I include the filed [SalesPerson Name] after the Report Footer I only get one sales person name the first one. I need to be able to see all of the them like I do in the first part.
if anyone can help I would really appreciate it. This must be a one page report. The report format is a must.

 

[gol4]

look at doing this via a subreport

 

[ssatech]

Math20,

Have you tried playing around with subform/subreport and linking your Sales Report and Sales Effectiveness to your report.

Sales Report = Main Report
Sales Effectiveness = Subreport