Sum Miscalculation Help

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

Marshall Barton

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