Double Counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a report for our company fees. But in some duplicate cases it
double counts, (well sums), it twice.

Is there a way to prevent this, I do not want to delete these occurances

Thanks Steve...
 
I'm not sure anyone here has a clue why you are getting double counts. Are
there duplicates in the report's record source that could be removed? Are you
using code to calculate the values?
 
No, no code just a standard query. The duplicates do show in the query but
not the table source. The query seams to be generating the duplicate items.
But I am afraid of deleting them, because they may delet the single entry in
the table...

The report is running correct, the problem is the query.

Is there a way to remove the duplicates from the query without effecting the
source data in the table?
 
You can change your query into a totals query. This will allow you to group
by some fields and aggregate others with Sum, Avg, etc.

If you don't understand why you have duplicates than you either don't
understand your data or your SQL. You may need to pare your query down to
just a couple tables and fields in your output to determine the cause.
 
Back
Top