Sum Miscalculation Help

  • Thread starter Thread starter Ray Todd Jr
  • Start date Start date
R

Ray Todd Jr

I've created a temporary database to do some quick calculations. It hasn't
turned out too quick, however.

The sum and count functions are taking the totals and multiplying by 2.
What do I have in the query that would muliply the totals by 2?

here is the sql:

SELECT taBusinessTaxAssessments.[Acct #], Sum([Tax Due]) AS TotalTaxDue,
Count(taBusinessTaxAssessments.[Acct #]) AS NumberofAccts
FROM taBusinessTaxAssessments
GROUP BY taBusinessTaxAssessments.[Acct #]

Thanks,

Ray.
 
Ray said:
I've created a temporary database to do some quick calculations. It hasn't
turned out too quick, however.

The sum and count functions are taking the totals and multiplying by 2.
What do I have in the query that would muliply the totals by 2?

here is the sql:

SELECT taBusinessTaxAssessments.[Acct #], Sum([Tax Due]) AS TotalTaxDue,
Count(taBusinessTaxAssessments.[Acct #]) AS NumberofAccts
FROM taBusinessTaxAssessments
GROUP BY taBusinessTaxAssessments.[Acct #]
Click to expand...


Nothing wrong with that SQL. It sounds like your table has
a lot of duplicate records.
 
Back
Top