Footer subtotal parameter prompt error

K

Kelly

Good Morning - I am writing a report that has many different groupings. I am
not trying to build subtotals in the footers.

So for instance, say there are 4 grouping levels A-D. The lowest grouping D
has a subtotal from two subreports contained in the detail of grouping D.
The field name for the grouping D subtotal command is called TotalGroupD. I
am now trying to create a subtotal in grouping C of all of the grouping D
subtotals.

Right now I have the control source in a text box that reads
=SUM([TotalGroupD]). When I run the report it is asking me for the parameter
TotalGroupD.

What am I doing wrong that it just won't run automatically? For what I need
there should not be a parameter to enter.

Thank you in advance for any help you would be able to offer with this. -
Kelly
 
K

Kelly

As soon as I posted this I changed my tactic and used the Group and Sort
button in the Ribbon at the top during the Design View. That was the
correction.
 

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

Top