View Full Version : Report based on a query has duplicate rows


clark
03-14-2002, 07:04 AM
Hello:

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
03-14-2002, 07:46 AM
Sounds like you have your sum in the detail section. If so move it to the footer.