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