Confused as to Why Totals in Report are Off from Qry

[melost]

Thanks for some help, scatching my head too long on this one. My totals in the query are fine. However, in the report it calculates the with 0's with amounts from the fields that have amounts (sum=forms.field). I started off by grouping the totals field (I only need the grand total). I also removed it from the header to the detail area and sure enough the amounts that were 0 in the query have dup values from the other rows. Any clues as to why it would be doing this if the query works okay.

melost

 

[dhookom]

Please provide some records from your report's record source and then how they appear in the report. Include the report section.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[melost]

Hi dhookom,

I kept investigating this further and it turns out that the query "was" really duplicating values. For some reason when I would filter by ID on the results, not all were visible. I exported the query into an Excel spreadsheet and sorted by ID, and there they were. Anyway, what I did was a "Group by Totals" on the query and that seemed to worked.

It seemed suspicious that their would be a separate Access report engine doing something else. Thanks for your assistance.

melost