Sum Miscalculation Help

[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.

 

[Marshall Barton]

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 #]

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