Report based on a query has duplicate rows

clark

New member
Local time
Today, 21:54
Joined
Mar 1, 2002
Messages
6
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.
 
Sounds like you have your sum in the detail section. If so move it to the footer.
 

Users who are viewing this thread

Back
Top Bottom