Report requests parameter value

[kkjewell]

Hello ... by problem:

Explanation:

Table has a single field (AllocAmt) that is repeated for each detail transaction. Therefore I can't put the sum of the single field on the report because it adds that sum times the count of the detail.

The solution I attempted was to create a subreport using a summarized query then divided the summarized AllocAmt by the count of the same field and got what I wanted. It worked beautifully. I named the calculated field and then created a sum of the new field (SumAllocAmt) in the subreport report footer. I ran the subreport and my totals came out fine.

Then I added the subreport to the original report and the information for each grouping came out fine.

Now my problem ... when I call the field ('=srptAllocAmt.Report!TotalSumAllocAmt") I created in the subreport report footer it does not give me the total for all groups in the original report. In fact it gives me the last record amount instead of a total. When I enter the expression "=Sum([sprtAllocAmt].[Report]![TotalSumAllocAmt])" and try to run the report a box pops up requesting a "Parameter Value" for the field sprtAllocAmt.Report!TotalSumAllocAmt. Why doesn't it recognize that I want a sum of the field contained in the subreport? I've gone to the properties box in all the subreport fields and made the data available "overall". I don't know what else to try. Any suggestions?

 

[kkjewell]

Found my own answer

Report was based on a query that contained two tables. Several of the fields had the same name, because they were the same field in both tables.
When I set up the relationship between the tables I only tied the key field.
When Access was running the report it couldn't tell which table to pull the info from so it just pretended it was a user input field and asked for the parameter value.

I solved the problem by creating a make-table query, combined the two tables into a new table with that make-table query and used the new table for everything. It sped up the processing time considerably also.

Hope this helps the 31 of you that have viewed this post, since no one had posted a suggestion.

I love this site, I'll be back