SUM & COUNT Functions are duplicating records in calculation

T

TNobles

I have a table of approx. 128K records. These records contain an account#,
date of service, & charges. I have written a query for this table to provide
a count of all accounts after a specific date and sum the charges; by month
and year. The query will successfully run, yet the total "count" of accounts
(Sum of January to December) is greater than the total records in the
original table. The query appears to duplicate a count. I would like to know
what caused this issue and to stop duplicating the "TOTAL" Functions for both
Sum and Count commands.
 
T

TNobles

Here is the SQL
SELECT [0507 - CONTRACTUAL TEST - IP].[Prim F/C], Count([0507 - CONTRACTUAL
TEST - IP].[Curr F/C]) AS [CountOfCurr F/C], Sum([0507 - CONTRACTUAL TEST -
IP].TotChgs) AS SumOfTotChgs, Sum([0507 - CONTRACTUAL TEST - IP].InsPmt) AS
SumOfInsPmt
FROM [0507 - CONTRACTUAL TEST - IP]
WHERE ((([0507 - CONTRACTUAL TEST - IP].DschDt)>#7/18/2006#))
GROUP BY [0507 - CONTRACTUAL TEST - IP].[Prim F/C]
HAVING ((([0507 - CONTRACTUAL TEST - IP].[Prim F/C])="CM"));
 
Top