I generated a report with simple calculated controls from a query that select 3 records. In the report I simply summed the columns from the query. The problem is that the totals appear 3 times, one for each query record when I only need it to show up once. Any ideas to fix this?

Thank you.


Jerry Stoner
Member posted 03-14-2002 08:46 AM
--------------------------------------------------------------------------------
Sounds like you have your sum in the detail section. If so move it to the footer.


thanks jerry, I tried your suggestion and now I get #error in each control, any suggestion?

Make sure that you have removed ALL controls from the detail section. Then look at the control name (Name on the Other tab). If any are the same as the names of the query fields, change them. So for example if your query's field name is AbcAmt, change the control name to txtAbcAmt.