Trying to count in a query, getting incorrect information

[Gina Maylone]

Here is my sql:
SELECT Account.DBAmt, Count(Account.dbamt) AS CountOfdbamt
FROM Account INNER JOIN Owners ON Account.member = Owners.OwnerKey


GROUP BY Account.DBAmt, Account.Lot, Owners.OwnerKey, Owners.NoAssessments, Account.Date
HAVING (((Account.DBAmt)=164.69) AND ((Account.Lot) Is Not Null) AND ((Owners.OwnerKey)=1185) AND ((Owners.NoAssessments)=False) AND ((Account.Date)=[Please enter last monthly assessment date])) OR (((Account.DBAmt)=54.9) AND ((Account.Lot) Is Not Null) AND ((Owners.OwnerKey)=1185) AND ((Owners.NoAssessments)=False) AND ((Account.Date)=[Please enter last monthly assessment date]));

Here are my results. Why aren't I getting 54.90=3 and 164.69=2?? Thank you for any insights you might have!

DBAmt	CountOfdbamt
54.9	1
54.9	1
54.9	1
164.69	1
164.69	1

[aytee111]

You are grouping on fields that aren't being displayed. One of them is the culprit. Show all the fields that you are grouping on for troubleshooting.