Totals Query

[Buddha1]

I have a query that is totaling the dollar amounts based on the type of credit card. I have a patient that was entered twice in the database because they paid on two different balances with a mastercard. When I run the query this particualr patients dollar amounts are twice the amount they should be. The patient is only in the database twice however the results are 190.08 when the total should be 95.04.

 

[cghoga]

Can you post your code?

In the meanwhile for kicks try inserting distinct in your SQL.

Select distinct...

Hope this helps.

 

[Buddha1]

SELECT DISTINCT TblSitePaymentInfo.Location AS Expr1, TblMain.Date, TblSitePaymentInfo.TypeOfCard, Sum(TblMain.Payment) AS SumOfPayment
FROM TblMain INNER JOIN TblSitePaymentInfo ON TblMain.[Acct #] = TblSitePaymentInfo.CreditCardNumber
GROUP BY TblMain.Date, TblSitePaymentInfo.TypeOfCard, TblSitePaymentInfo.Location
HAVING (((TblMain.Date)=#2/5/2004#) AND ((TblSitePaymentInfo.Location)="Per-Se&quot);