Trouble with sub-report to main report

G

Greg A

I am trying to teach myself access and having trouble. I have a report that
is laid out like this:

Salesperson Jan Feb Mar YTD
Product 1 sales
Product 1 objective
Product 1 % to objective

Product 2..
Product 3..
Etc.

Jan data is in the main report. I have a sub-report for each of the other
months.

All of the salespeople roll to a single manager. In the report footer, I
built an expression for each field:
Name: Febproduct1sales
Control: sum([product1sales])

I used the same expression in each of the sub-reports and changed the
"visible" property to "no".

In the report footer of the main report I wrote an expression:

=[febsubreport].[report]![febproduct1sales]

I have two problems I cannot figure out. 1) in the main report footer, it
is populating the product1sales results for the last salesperson - it should
populate the sum of all of the sales people. The sub-report has the correct
calculation. 2) It is also populating the product1sales results for the last
salesperson as the last field under each salesperson in the detail section of
the report.

What am I doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub-report total to main report 9
Report Group Footer DLookUp 0
Tagging Misspell Words with "##" 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report and subreport pulling from same query. 2
A03 - count in report footer gives me #Error? 0
Totaling Multiple Subreports 8
Sum of sub-form/sub-report 6

Top