returning strange values?

[A|ex]

I am having a problem with one of my queries, the problem i'm having it seems to be returning the same value 3 times and other values overwrite themselves.

Ive attatched a image because i cant really explain it.

Can anyone help?

Here is the SQL:

SELECT Customers.FirstName, Customers.LastName, Customers.ContractNumber, Sales.DateSold, Sales.DiscountGLPNett, Sales.SurveyNett, Sales.CashCommission, Sales.FinanceCommission, Sales.EmployeeID
FROM Sales, Customers, Employees, MarketingSource, (FinanceHouse INNER JOIN ProductCode ON FinanceHouse.FinanceHouseID = ProductCode.FinanceHouseID) INNER JOIN Term ON ProductCode.ProductCodeID = Term.ProductCodeID
GROUP BY Customers.FirstName, Customers.LastName, Customers.ContractNumber, Sales.DateSold, Sales.DiscountGLPNett, Sales.SurveyNett, Sales.CashCommission, Sales.FinanceCommission, Sales.EmployeeID
HAVING (((Sales.DateSold) Between [Start Date] And [End Date]))
ORDER BY Sales.DateSold;

 

[A|ex]

How would i get a simple display everything in sales? when i tried to display * it gave me 6840 records when there are only 3 enteries in the sales table

 

[A|ex]

I was playing around with that then i thought scrap it and try the ms access wizard. I think it auto joined them for me and the query works fine now