Identical Record Returns 1

[zach028]

I have a report that I am making for our collections department. I have a 2 tables, "promises kept" and "promises not kept" (we're finding out how many of those checks were actually in the mail). I use two queries to summarize data from each table. The queries work fine separately and return a summarized total for each collector. The report is linked to the queries and only has three fields. It gives me the summarized values, but gives the sums many many times over for each collector. Using the "Hide Duplicates" does not work because it leaves huge gaps in my report.
This should be very simple. What am I doing wrong??!!

 

[MichaelRed]

Assuming (A very poor idea) that the report is really being based on a query which 'joins' the tables (stop here is the assumption is false), the join(s) in your query are not correct.

If you post the table structures and the query sal statements, it is probable that the issue could be resolved.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[zach028]

I don't doubt you are right on this.
I re-made a new report using the wizard and it came out fine this time. Fool that I am, I don't think I linked my two sub-queries to the table the first time through.

Zach